Unanswered

British Date/Time Format - Convert Date

(0) Share

Report

Posted on by BP-PT

Hello,

Trying to convert time, whilst also re-formatting to british format (ideally after: dd/mm/yyyy - [time]), but am not having much luck.

Please see attached for current setup for the time conversion specifically.

Any help would be greatly appreciated 🙂

Thanks,

Billy

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (0)

Ellis Karim 11,931 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Can you post the source Date/Time you are trying to convert along with the results of the Convert Time Zone action.
What appears to be wrong with the conversion?
Ellis

Was this reply helpful? Yes No
Ellis Karim 11,931 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

I see the issue. Please use MM (caps) for month:
"11/08/2021 06:56 PM"

Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
BP-PT 92 on at

Like (0)

Report
Copy link

Link copied!

Thank you - much appreciated.

Am I able to now set the converted time +30 mins as the end time for a calendar entry that I then want to spin-off from this?

Was this reply helpful? Yes No
Ellis Karim 11,931 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

You can try using the Add to Time action to add 30 mins
Convert time:
Add to time:
Ellis

Was this reply helpful? Yes No
BP-PT 92 on at

Like (0)

Report
Copy link

Link copied!

Thanks for that.

Unfortunately, that's now providing me with the following error. I've also attached the settings too, to hopefully make things more clear.

Thanks,
Billy

Was this reply helpful? Yes No
Ellis Karim 11,931 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Try using the following Format string:
as your scheduled date is in the format yyyy-MM-dd hh:mm 2021-08-12T17:23:38Z . Format string "yyyy-MM-ddThh:mm:ssZ" will probably work too, and should give you the same results.
Converted to 06:23 London time:
06:23 add 30 mins gives 06:53:
You can further format the new date and time to your needs:

Ellis

Was this reply helpful? Yes No