Date Conversion dd MMMM yyyy to yyyy-MM-ddT00:00:00

(0) Share

Report

Posted on by laserdash

Hi All,

I am extracting information from certain formatted PDF Documents - Flight Tickets - to import this to a Calendar.

Everything is working as it should, but I cannot get the date conversion to work. I have searched through many a forum, and I might just not understand how to get it done. I have very limited programming knowledge, so I need someone to explain in laymans terms how to get it right.

Total Flow.JPG This is an overview of my flow. I would assume I need to know which information needs to be supplied for Initialize Variable, and for Set Variable, and then I need an outline of which Formula to use when I format the Start Time and End Time for the event that I am creating.

The Dates from the Flight Tickets come in 01 January 2022 or 12 October 2022 format, and I need them changed to 2022-01-01T00:00:00 or 2022-10-12T00:00:00.

Please let me know if there is any other information required.

All responses (2)

Answers (1)

laserdash 4 on at

Like (0)

Report

Re: Date Conversion dd MMMM yyyy to yyyy-MM-ddT00:00:00

So I now found out it actually formats itself, and the document I used did not read correctly with the AI Builder, hence my issue, but this above did format my date as I requested, Thank You very much.
Verified answer

StretchFredrik 2,778 Super User 2025 Season 1 on at

Like (0)

Report
Re: Date Conversion dd MMMM yyyy to yyyy-MM-ddT00:00:00

Hello,

try the following

formatDateTime('<your-value>', 'yyyy/MM/dd hh:mm tt')