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
Solved! Go to 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
Hi Roland,
Formula worked!!. Thank you.
Regards
Mounika.