Week number and the next weeknumber using Table transformer

[Chris]

Hello,

We want to display the current week number and the next week number in two rows of our table. I have understood that this may be possible using the table transformer macro. However, I am not sure what SQL Query to write for this. can someone help with this. Our aim is that the week number automatically updates itself in the column depending on the current week. We are on Confluence Data center.

Thanks

[Chris · Accepted solution]

This is resolved. Please don't worry.

[Stiltsoft support]

Glad it works!

Maybe for other users if they come across this question: you may try the following SQL query

SELECT
FORMATDATE("today", "w") AS 'Current Week Number',
(FORMATDATE("today", "w"))::number+1 AS 'Next Week Number'
FROM T1

Hope it may help.

[Chris]

This was my solution. Not an expert at SQL queries, but worked something out after googling things:

SELECT FORMATDATE(GETDATE()) AS 'Current CW', FORMATDATE(DATEADD(week, 1, NOW())) AS 'Next CW' FROM T1;