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 am trying to convert Jira dates (Nov 1, 2023) to w-yy (44/23) from a column in a table using Table Transformer in Confluence Server. I have tried many SQL queries with no success.
Can anyone provide a simple way to do this?
Here is the test data I've been working with
i1 Jun 10, 2023
i2 Aug 12, 2023
i3 Jan 29, 2024
Hi @Sophia Kroening ,
Please try the following SQL query:
FORMATDATE('Date', "w/y") AS 'Converted Date'
The Date format in the Settings tab should be set as "M dd, yy".
Hope it helps your case.