preset a date on the date macro

[Butch_Richards]

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 

[Stiltsoft support]

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:

[Butch_Richards]

@Stiltsoft support  can I refer to it in JSON ?

[Stiltsoft support]

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.