Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
How can I extract the month number out of a date field in a calculated field? I tried this expression, but it won't work:
=Month(Date([DateField]))
I get the month's short name even though I discarded the variable declaration at the beginning of my script:
/*SET MonthNames='janv.;févr.;mars;avr.;mai;juin;juill.;août;sept.;oct.;nov.;déc.';*/
Can anyone help?
Thanks.
num(Month(Date([DateField])))
Thank you Krishna!
Do you know how I could get the month number to look like 01, 02, 03, 04 ... 10, 11, 12? Thanks again.
Try num(Month(Date([DateField])),'00')
OR Num(Date(DateField,'MM'),'00')