date in to month

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.

Accepted answers

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 😀👍

Formula would be

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

Hope this helps🙂

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 😀👍