convert to only month and year from string

[adarsh2608]

I have a number which is in 202201 how can i  convert to date format ( year and month 2022-01 )

[binuacs · Accepted solution]

@adarsh2608 this can be done by using the datetime functions

[alexm06 · Accepted solution]

Hi adarsh2608,

As long as the date is always in the format yyyymm you could use Left and Right functions in a Formula tool to add a "-" to separate the year and month before using the DateTime tool to convert the field type to DateTime. 

I've attached an example workflow.

Does that solve your problem?