Trying to get a date entered on a Confluence page to copy to several other tables

[Tim Rice]

I have a Confluence page where I want a date (call it Discovery Date) that is entered in one section of the page to fill to several other sections to calculate other benchmark dates (e.g. Discovery Date +30 days, +60 days, etc.  I know I have to use Table Transformer macro, and I think Table Excerpt, but I can't get it to work.  Thanks!

[Stiltsoft support · Accepted solution]

Hi @Tim Rice ,

If you are stuck, you may refer to our support. We'll need your page storage format (upper right corner of the page -> menu ... -> View Storage Format), so that we'll be able to recreate your exact page with your source table, your macros, and the queries inside them. Then we'll be able to guide you through the case.

Meanwhile, you may look into a very similar case with the Table Transformer macro: https://community.atlassian.com/t5/Confluence-questions/Ho-do-I-calculate-date-plus-days-without-weekends-in-Table/qaq-p/1562965

And you may also check the documentation regarding the Table Excerpt/Table Excerpt Include macros if you need them to reuse your source table across your Confluence instance.