Date Function

[Mounika1]

Hi,

I have a field in my date in the below format.

12/16/2019 4:32

can I pull the month from this field. pls help

Regards,

Mounika

[RolandSchubert · Accepted solution]

Hi @Mounika1 ,

iyou have to convert the date to the date data type  in a first step. Then you can use DateTimeFormat to extract the month. The formula

DateTimeFormat(DateTimeParse([Field1], '%m/%d/%Y'), '%B') will return the long name (e.g. "December")

DateTimeFormat(DateTimeParse([Field1], '%m/%d/%Y'), '%b') results in the short name ("Dec")

DateTimeFormat(DateTimeParse([Field1], '%m/%d/%Y'), '%m')  give the number ("12")

Hope this solves your problem.

Best,

Roland

[Mounika1]

Hi Roland,

Formula worked!!. Thank you.

Regards

Mounika.