date in to month

[Narresh4ut]

i am trying to convert the date filed(YYYYMMDD) in to YYYYMM to see data by month. example i.e. date 20201116 = November 2020 like wise.

The source data connected from MS database and date filed is showing as string. Any suggestion it would be help full.

[atcodedog05]

Hi @Narresh4ut 

Formula would be

DateTimeFormat(DateTimePrase([Field],"%Y%m%d"),"%B %Y")

Hope this helps🙂

[atcodedog05 · Accepted solution]

Hi @Narresh4ut 

Here is a workflow for the task.

Workflow:

DateTimeFormat(DateTimeParse(ToString([Field1]),"%Y%m%d"),"%B %Y")

DateTimeFormat(DateTimeParse(ToString([Field1]),"%Y%m%d"),"%Y %m")

Hope this helps 🙂 Feel to ask if you have any questions

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[atcodedog05]

Happy to help 🙂 @Narresh4ut 

Cheers and Happy Analyzing 😀

Feel free to reach out if you face any issues 🙂

[Narresh4ut]

Thank you...this what i need exactly ..:)