Last_Day SQL function does it exist in ACS?
I need to add a formula in a workflow which should be based on the last date of the month for a given date.
This was originally done in SQL by using the function:
DATEFIELD > Last_Day(Add_Months(Current_Date+1,+4))
Now I am trying to replicate this result in ACS.
I am to this point:
@DateField > ToDate(DateOnly(AddDays(GetDate(), 120))) is there a way to make sure this calculation is based on Last_Day?
Thanks,
Elisa