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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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;
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.