Conveting a date

[rcandeo]

Hi, I need that the result of the code above be like this: '2001/02', but it's bringing me '2001/2'

year(today())&'/'&num(month(today()))

How can I fix that please?

[Miguel_Angel_Baeyens · Accepted solution]

Hello Robson,

That's because of the Num() function, as in numbers, a leading zero doesn't make the difference. Try instead

Date(Today(), 'YYYYMM')

Hope that helps.

[spividori]

HI.

Try the following:

date(monthstart(today()),'YYYY/MM')

Regards.