Format date

[Carlaf_93]

Good morning,

i'm importing a field that shows the month's names.

I would like to get the number's format.

If i use the num function it gives january like 1.

How can i get 01?

Thanks

[Taoufiq_Zarra]

@Carlaf_93  like  ?

num(Month,'00')

[Chanty4u]

Hi,

try this too,

num(Month(field name), '00')  as MonthNum