Previous MonthYear based on today

[kevbrown]

Hi,

I'm looking to get a YearMonth field for the previous month based on todays date, this ideally needs to be TEXT.  So for today I would like to 2017/06

Thanks

Kev

[Anonymous]

Hi,

Try:

date(addmonths(today(),-1),'YYYY/06')

[Anonymous · Accepted solution]

date(addmonths(today(),-1),'YYYY/MM')

[kevbrown]

Perfect thanks