Month number out of date

[alkyde01]

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.

[Qrishna]

num(Month(Date([DateField])))

[alkyde01]

Thank you Krishna!

[alkyde01]

Do you know how I could get the month number to look like 01, 02, 03, 04 ... 10, 11, 12? Thanks again.

[jerifortune]

Try num(Month(Date([DateField])),'00')
OR Num(Date(DateField,'MM'),'00')