Date & Time - how to drop the seconds

Hi All,

I looking for advise on how to alter the format of the date and time included in my data.

Currently, I have a column that list the date and time of events in the following format 8/14/2019 12:39:48 PM. I need for it to look like this 8/14/2019 12:39 PM.

Any thoughts?


Hi @chimdee,

you can first convert this string to a data and time type using the String to Date&Time node with the format M/d/yyyy hh:mm:ss a. Then, convert the date&time back to a string with the Date&Time to String node. Here, use as format M/d/yyyy hh:mm a.



Hi SimonS,

Thank you for the response. I don’t see the date formats that you have listed in you response. Do I need to change my locale? I’m currently using en-US.


The locale should be fine. The formats are not in the selection but you can just enter them directly into the field.

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.