We are using a date type variable with range.
Within the range of values, we would like to use an expression to get the previous month, first and last day of the previous month.
Do we have any expression to get these values?
Thanks
Help with Date variable with Expression
-
- Posts: 63
- Joined: Mon May 30, 2022 7:35 pm
Help with Date variable with Expression
- Attachments
-
- variavel data faixa.png (10.49 KiB) Viewed 6054 times
-
- Posts: 6964
- Joined: Tue Mar 20, 2018 5:34 am
Re: Help with Date variable with Expression
Hello,
You can use the DateSerial() function, for example:
DateSerial(Today.Year, Today.Month - 1, Today.Day)
Thank you.
You can use the DateSerial() function, for example:
DateSerial(Today.Year, Today.Month - 1, Today.Day)
Thank you.