Month Function

[#1]

hi All,

I need to store a value in the variable of last month in this format '07/17'

Month(Today()) gives value as Aug

Month(today())-1 gives value as 07

but I need the output as 07/17

please advise

thanks in advance

Sukhwant

[sunny_talwar]

May be this

Date(MonthStart(Today()), 'MM/YY')

[Frank_Hartmann · Accepted solution]

=num(Month(today())-1,'00')&'/'&right(Year(Today()),2)