"Date" macro date cannot be detected by the table transformer's SQL query.

[Sumant Shetty]

We have multiple documents within a tree structure, on the main parent page, we have used the Page properties report macro get the relevant details of the pages below.

We were trying to use the SQL feature of table transformer macro to use SQL to tag RAG status to these documents based on the 'Due by' date on each page.


But we are not able to get the dates from the Date macro. We also tried to get just the date in a new column but were not able to do so.


We are also trying to convert the Date format into a new column, so it can be detected by the table Charts macro, but we are unable to do so.
Even the charts are able to detect these dates.


Any guidance on this is appreciated.
Thank you.

[Stiltsoft support · Accepted solution]

Hi @Sumant Shetty ,

Please note that you need to set the corresponding Date format inside your macros.

For the Table Transformer macro it will be in the Settings tab:

And for the Chart from Table macro it will be in the Adjustments tab:

Pay attention that you set the correct format in the macro settings and not in the Preview window.

If you are still stuck, you may refer to our support and share your source table - we'll help you with the case.