how can I preset a date on the date macro in confluence to now.PlusBusinessdays(5) this folows the syntax on the atlssian dcumentation but willnot set the date macro using filed definition rules for set date
Hi @Butch_Richards ,
Maybe we've got the idea wrong but if the requirement is to show a date on the Confluence page that is 5 days after the today date excluding weekends, we can suggest trying the app that we develop - Table Filter, Charts & Spreadsheets for Confluence.
Here is another Community question that shows how to count dates from the specific start date excluding weekends and here is a modified variant for your case:
SELECT *,
FORMATDATE(DATEADD(day,
T1.'Period' +
2 * FLOOR(T1.'Period' / 5) +
CASE
WHEN "today"::Date->getDay() = 0 THEN 1
WHEN "today"::Date->getDay() = 6 THEN 2
WHEN ("today"::Date->getDay()) + T1.'Period' % 5 > 5 THEN 2
ELSE 0
END,
"today"))
AS 'End Date'
FROM T1
The output of the macro may be modified to show the result as plain text as well:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Not sure that I got the question - please can you elaborate more? Maybe you are talking about Jira smart values or smth? https://confluence.atlassian.com/automation/jira-smart-values-date-and-time-993924864.html
Our macros work with Confluence and are used to transform and calculate data in tables - so you'll be able to virtually show them as you need.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.