What is the expression for slicing dates that are in the last calander month

[antproberts]

Please can someone help?  What is the expression for slicing dates that are in the last calander month i.e

01/04/2022 - 30/04/2022

01/05/2022 - 31/05/2022

Last month expressions seem literal as is last month from todays date.

[Rafael_ANEIC-PY · Accepted solution]

Hello @antproberts, how about these?

source: https://help.appsheet.com/en/articles/2430932-eomonth

For your slice expression for "last month":

MONTH([dateColumn])=MONTH(EOMONTH(TODAY(), -1))