Date/Time format issue

[Tippers]

When I capture a requested appointment date and time from an email, and then try to format it so GoHighLevel can use the data I get the wrong time. this is the format I get from the email: May 13, 2024, 6:00:00 p.m. The choices for date and time input do not correspond with what I have to use. Is there a way to change am/pm time to military time? I would like to input the date/time into the formatter with MMM DD YYYY hh:mm:ss A but that isn't an option in the formatter. Does anyone have any ideas on how I could get this achieved?

 

[Supreme]

Hey @Tippers

Indeed, you can toggle the Map button and add the 'To' and 'From' formats in the Date Time Formatter to process the date according to your requirements.

E.g. -

 

[Tippers]

Thanks @Supreme
Now it does not return an invalid output. However, it is returning the current date and time.

Here is my result from the email parser, and the formats I tried to use.
Where did I go wrong?

 

[ArshilAhmad]

You can achieve the desired result in this manner:

Pabbly - Online Marketing & Sales Software

Automate your sales and marketing with Pabbly. Unite email marketing, lead capture, WordPress themes, subscription all at one place.

connect.pabbly.com