Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Convert Date with SQL in Table Transformer

Sophia Kroening November 1, 2023

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

1 answer

1 accepted

2 votes
Answer accepted
Stiltsoft support
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 2, 2023

Hi @Sophia Kroening ,

Please try the following SQL query:

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

Thu 7-1.png

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

Hope it helps your case.

Sophia Kroening December 7, 2023

Thank you! This worked perfectly

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
TAGS
atlassian, atlassian community, job interviews, interview tips, career advice, interview preparation, job search, interview experiences, hiring process, atlassian careers, community discussion, interview best practices

Interview Tips & Pet Peeves ✍️

Join the discussion on interview best practices and common pitfalls. Share your experiences and learn from others in the Atlassian Community.

Share you experiences!
AUG Leaders

Atlassian Community Events