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)
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
(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.
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.
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
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!
