Date & Time - how to drop the seconds

[chimdee]

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?

Thanks

[SimonS]

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.

Cheers,
Simon

[chimdee]

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.

Thanks

[SimonS]

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