Issue Related to Month Date Format

[Giovane]

Who can help me?

When I do Month(Date) - And Date has the format DD/MM/YYYY - I got, for example, dez as the result. How do I do to get 12, instead of dez, as the result? 

Thanks a lot !!!

[m_woolf]

Try:

num(Month(Date))

[nilaksh92]

Please try to implement like this.

=Num(Month(Date(now(),'DD/MM/YYYY')))

[MindaugasBacius · Accepted solution]

I would like to improve Mwoolf solution a liitle:
Num(Month(Date), '00')

Now you will get 01, 02, 03 ... 12. In times when you will for example concatenate Year and Month as 2019-01, 2019-02, 2019-03 ... 2019-12 that will provide consistent visualization.
Without formatting you will get 1, 2, 3 ... 12 and Year month field will look like this 2019-1, 2019-2, 2019-3 ... 2019-12.

[Giovane]

Best answer...your tip fixed completely my issue.

Thanks for all the contributions.