How to convert $ascii $ text to date

[raZor]

Hi All,

I have dates like July 26, 2023.

How to conver to date?

Thanks in advance,

Qliker

[marcus_sommer]

If all period-parts are properly covered from your interpretation variables (usually at the beginning of your script) you may use:

date(date#(YourField, 'MMMM DD, YYYY'), 'DD.MM.YYYY')

[raZor · Accepted solution]

Hi, 

Thanks for replying, how about December 12, 2023?

date(date#(YourField, 'MMMM DD, YYYY'), 'DD.MM.YYYY')

As MMMM is ok for July but for all months?

Regards,

[marcus_sommer]

The mentioned interpretation-variable with the listing of long monthnames must be identically to the format-pattern of this date-field and then all dates would be correctly recognized. These variables mustn't be mandatory static at the beginning of the script else they could be changed multiple times within the script - if there is any need to handle anything differently.