Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
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.
HI.
Try the following:
date(monthstart(today()),'YYYY/MM')
Regards.