Date / Time Formatter Customized Format

[finkeez]

Hi
I see pre-defined time formats on Pabbly.
Is there a way to get a customized time format. For example I need hh:mm ddd but there's no option in the Date / Time Formatter .

How do I go about this?

 

[Arshita]

Hey @finkeez

To enter the date and time in your format, you will need to enable the Map option. By enabling this option, you can enter the format of date and time.

I kindly request you to enable the Map option and enter the date and time in the desired format. After doing so, please try again and let me know if you are facing any issues.

 

[finkeez]

Hi. While the mapping works the way you said, I have two date-time-formatters in a sequence, each for different format results. One is somehow overwriting the other. You may see the below case. While Trans Month is okay, Trans Date Time is not right.

Output

Pabbly For Trans Month

Pabbly For Trans Date Time
While the Test looks okay, it's not the same in the google sheet.

 

[Arshita]

In this case, I request you to use the plain text content instead of any other option in the columns, and after this please try to capture the data again.

Please let me know if you are still facing the same issue.

 

[finkeez]

Works. Thank you !