topic Re: Month number out of date in App Development

Month number out of date

alkyde01 — Wed, 18 Apr 2018 15:28:50 GMT

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 — Wed, 18 Apr 2018 16:02:51 GMT

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

alkyde01 — Wed, 18 Apr 2018 16:24:19 GMT

Thank you Krishna!

alkyde01 — Wed, 18 Apr 2018 17:25:17 GMT

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

jerifortune — Wed, 18 Apr 2018 20:39:43 GMT

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