month in Two digits

[adiarnon]

HI,

i want to get the current month in two digits. (01,02,03,04,05,06,07,08,09,10,11,12)

i need a expression - but without an IF.

can someone help?

[swuehl · Accepted solution]

num(MonthField, '00')

[Ibobob70]

Hi

what if I have 2 digits month number and i want month name?

[BrunPierre]

Date(Date#([Month Number], 'MM'), 'MMM')

or

Pick(Match([Month Number], '01', '02', '03', '04', '05', '06', '07', '08', '09', '10', '11', '12'),
'January', 'February', 'March', 'April', 'May', 'June', 'July', 'August', 'September', 'October', 'November', 'December')

[luizclaudio]

Does the monthname(data) function not solve what you need?