replace string element from a time stamp

Hi Everyone.

I have a column of ascending timestamps that are spaced in 10 minute intervals, What I are I am trying to do is to replace in each timestamp the minutes with 00 ie
2022-11-30T00:10 to 2022-11-30T00:00
2022-11-30T00:20 to 2022-11-30T00:00. and so on for all the column

I am guessing this should be something that the String Manipulation node ought to be able to complete but i am probably missing the config of the replace function.

Any pointers would be really appreciated.

There are modify date and modfy time nodes (in case it is already treated as a date)

1 Like

Yes i think i tried those but unlike Alteryx they dont seem to allow a custom field but just the presets

Modify Time allows you to overwrite time e.g to 00:00 so it should work.

1 Like

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