Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,298,597
Community Members
 
Community Events
165
Community Groups

Auto calculate dates based on PAC-0

R-Date

Target Date (Tentative)

Activity

PAC-4<DD-MMM-YYYY>Project Team Review (Phase 2 team approval)
PAC-3

<DD-MMM-YYYY>

Desk Review with Product Operations
PAC-0

<DD-MMM-YYYY>

Pre-PAC Review 

 

Hey guys,

Here is my usecase:

I want to use the table transformer macro in confluence to automatically calculate dates for PAC-3 and PAC-4 based on PAC-0 date that I would manually provide. 

Ex: I'll mention PAC-0 date as 20-May-22 and I want PAC-3 to automatically calculate 17-May-22 and PAC-4 date as 16-May-22. I'm getting an error in the SQL query. Can someone help pls?

 

 

1 answer

Hi @sindhushandilyaa ,

We assumed that the number after your PAC- is a number of days to subtract from the PAC-0. So our developers came up with the following solution:

Mon 7-1.png

Don't forget to set the correspondent date format:

Mon 7-2.png

And use the following SQL query:

SELECT T1.*, FORMATDATE(ADDDATE(TT1.'Base', INTERVAL T1.'R-Date'.split("PAC")->1 DAY)) AS 'Target Date (Tentative)' FROM T1, (SELECT 'Target Date (Tentative)' AS 'Base' FROM T1 WHERE 'R-Date'="PAC-0") AS TT1

Mon 7-3.png

Hope this helps your case.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Confluence

An update on Confluence Cloud customer feedback – June 2022

Hi everyone, We’re always looking at how to improve Confluence and customer feedback plays an important role in making sure we're investing in the areas that will bring the most value to the most c...

208 views 1 4
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you