Converting String to Date

[JeniferReid1]

Hello,

I have a field called Period which contains text in the format of Month Year. Ex: OCT 2021,

Is it possible to convert this to a Date format so it displays as: 10/1/2021 or even 10/2021?

Jenifer

[h_kleine]

You can use the DateTime Parse tool to convert to date. 

[atcodedog05]

Hi @JeniferReid1 

You can get datetime formulas like below to get the desired formats.

Workflow:

Hope this helps : )