Formula to Find the END Date

DataPirate26

Hello, 

In this Workflow attached below The End Date needs to be updated as such It will be the Last day of the Next month from current date. So for example If current date is 2021-12-17 then the End Date needs to be updated as 2022-01-31. So basically the year needs to be changed dynamically. Can anyone help me to update the Formula. 

The workflow is attached below. 

Test.yxmd

AngelosPachis

Hi @DataPirate26 

Maybe you can try

Datetimetrim(
DateTimeAdd(
DateTimeTrim([Current date],"firstofmonth")
,1,"month"),
"lastofmonth")

What this is gonna do is take your current date field and force it to the first of that month (so 2021-12-17 will become 2021-12-01). The you will add a month to that date, so 2021-12-01 will become 2022-01-01 and finally you will trim that to the end of the month, so 2022-01-31.

Hope that helps,

Angelos