Max date in Table Tranformer

[Leona Vo]

Hi,

I have a very simple table that list the jira tickets and their due dates. I want to find the farthest out due date. Using the Table Transformer, I have this simple query that produces the wrong date. I expect 8/19/22 to come back, but it came back with 5/31/22 which is one date from a list of many with 8/19/22 being the furthermost out.

SELECT FORMATDATE(MAX(T1.'Due')) FROM T1

or

SELECT FORMATDATE(MAX('Due')) FROM T*

Both produce the same wrong results. What am I missing?

Thank you.

[Alexey Mikhaylov _Stiltsoft_]

Hello Leona,

Thank you for using our Table Filter and Charts for Confluence app.

Please check that Date format in your Table Transformer macro browser corresponds to the dates from the Jira Issue macro. Usually this is the one specified in the screenshot:

And use the following SQL query:

SELECT FORMATDATE((MAX(T1.'Due')),"m/d/y") FROM T1

The part in bold is where you can specify the date format you would like to see as a result. In my example it will be as follows:

Best regards,
Alexey