Hi There,
Based on a date, i would like to create a column that provides semi-monthly dates.
I.e
Date starts 01/01/2021
the next date would be + 15 days = 01/15/2021
the next date after that would be +16 days = 01/31/2021
would you be able to assist me.
Thank you,
Hi @Tim6
You can use DateTimeAdd expression.
If you would provide the date "2021-01-01", you can output the bellow result by using DateTimeAdd expressions in Formula tool.
The result is as follows.
Hi @Tim6
Here is a solution if you want next day after as last day of the month since you mentioned semi-monthly.
Workflow:
Hope this helps : )