Convert to Date

[SteveFord]

Hi all,

Any ideas to how I can convert the below string to a date, ie. 2021/06/24:

Thu Jun 24 2021 13:36:58 GMT+0100 (British Summer Time)

[DawnDuong]

(I just realised that i mis-read your question - pls refer to Emil's reply instead)

hi @SteveFord 

There are a couple of ways. - shown in the attached are 2 methods.
Dawn.

[Emil_Kos]

Hi @SteveFord,

As the first 4 characters are irrelevant I removed them with a substring formula.

After that, I have used date time parse to transform the data into a proper one.

[KarolinaRoza · Accepted solution]

hi @SteveFord ,

Another possible solution:

- Regex to filter for string "Mon dd yyyy"

- DateTime tool : to convert string to date format.

You can choose which suits you the most 🙂

Regards,

Karolina

[Jonathan-Sherman]

Hi @SteveFord,

You could cut straight to it with a DateTime tool, no need for string calcs or Regex. Just specifying the correct incoming string field format will give you what you're looking for:

day Mon dd yyyy hh:mm:ss

Input:

Output:

I've attached my workflow for you to download if needed!

Kind regards,

Jonathan

[Jonathan-Sherman]

Or if you're just looking for the Date and not interested in the time part, in your DateTime tool you could simply use:

day Mon dd yyyy

I've attached an updated workflow for you to download if needed!

Kind regards,

Jonathan