Date Formatting

[rebecca_shopp]

I have a date in this format 20230309. I would like to change the formatting so that the month and year are showing. My ultimate goal is to use the Summarize tool to group all the dates by month and year.  I've tried various formulas without any success. 

I have also tried changing the format of my date from VString to DateTime and that did not solve the problem. 

Thank you!

[MarqueeCrew]

Hi @rebecca_shopp ,

The SIMPLE solution is:

Left([YourDateField],6)

This gets you 202303.  That should be easily sorted for you.

Cheers,

Mark 

[nagakavyasri]

[rebecca_shopp]

Thank you, sadly this did not solve the issue for me. 

[nagakavyasri]

The input '20230309' needs to be converted to Date format before using Text to Columns tool. Attached workflow in previous comment.