Need help with Date Format

[jcoleman13]

Hi All, 

I have a string field with a date value written out as:

December 27, 1991

How do i get it to be in a date format, like:

1991-12-27

I've tried formulas, regex, DateTime... cant get it to work.

Thanks,

Jeanne

[davidskaife · Accepted solution]

Hi @jcoleman13 

DateTime should work, make sure you're selecting the format that matches the string:

[jcoleman13]

Thank you @davidskaife I was selecting the wrong format. Sometimes its right in front of your face, and you just dont see it.

Thanks again!