Convert Date with SQL in Table Transformer

[Sophia Kroening]

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

Item Date

i1      Jun 10, 2023

i2      Aug 12, 2023

i3      Jan 29, 2024

[Stiltsoft support · Accepted solution]

Hi @Sophia Kroening ,

Please try the following SQL query:

SELECT *,
FORMATDATE('Date', "w/y") AS 'Converted Date'
FROM T*

The Date format in the Settings tab should be set as "M dd, yy".

Hope it helps your case.

[Sophia Kroening]

Thank you! This worked perfectly