Convert Month to Number or Text

khoonks
khoonks
in Modeling

If we use the the MONTH function to convert a month - for example "Jan 15" which is month formatted to Number, the outcome is "1" and not "01"

My requirement is to turn "Jan 15" as 201501. So I wanted to convert Jan to 01 instead of 1 and after that I can concatenate to get the result. What would be the way to convert Jan to 01 instead of ?

Tagged:

Answers

  • AjayM
    AjayM

    Hi @khoonks ,

    Similar to MONTH function, we have YEAR function to retrieve respective year value in number format.

    To convert 1 to 01 for Jan, you should use a small conditional statement with concatenation, as below:

    image.png


    Cheers!

  • aakash
    aakash

    Hi @khoonks,

    Here you go

    image.png

    Regards,

    Aakash Sachdeva

Categories