You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
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
SELECT FORMATDATE(MAX('Due')) FROM T*
Both produce the same wrong results. What am I missing?
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: