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
The target date format is 11-Feb-2022.
But when I use this format, the date sorting is based on number and then alphabet (believing it is a string now) . Let me show you the picture.
I change the date format into d M yy in table edit page in setting and then it looks like the picture.
And one more thing : when the format is M - D -YYYY , there is 0 in front of some date cell, Please check the [Pre Date].
all data are from jira.
Here is the JQL
FORMATWIKI(SUM('ITEM'+"\n")) AS 'Item',
FORMATWIKI(SUM( ’Date'+ "\n ")) as 'Date',
FORMATWIKI(sum('Pre Date'+"\n" )) as 'Pre Date',
SELECT 'Import', 'Item' ,
FORMATDATE('Date') as 'Date',
FORMATDATE('Pre Date') as 'Pre Date'
FROM T* ORDER BY 'Item' , 'Date' ASC
GROUP BY 'Item'