We need a function to get in a simple way the last day of a month.
Today I do this by using below functions and works, but is so complex:
"@adddays(concat(add(int(formatDateTime(utcNow(), 'yyyy')),if(equals(formatDateTime(utcNow(), 'MM'), '12'), 1, 0) ),'-',add(int(formatDateTime(utcNow(), 'MM')),if(equals(formatDateTime(utcNow(), 'MM'), '12'), -11, 1) ),'-01T00:00:00Z'),-1)"
A function like startOfMonth would be amazing.
Regards,
Gustavo Moraes
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This is a great idea, thank you!