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

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.