Converting time stamp field

Hi,

I have a situation where I have 2 fields.

One field is coming in as for example - '2017-07-07 00:40:08'

I want to be able to convert it so that it becomes '2017-07-27 00:00:00'.

I have searched on the community but I am not able to find the function that would zero out the hours/minutes/seconds. I will continue to look but if anybody knows about it, please let me know. Thanks in advance!

Common Use Cases

Accepted answers

Kenda

@iRm one option would be to create a new string field with the following expression: REGEX_Replace([Field1], "(.*)\s(\d\d\:\d\d\:\d\d)", "($1) 00:00:00"). Then, if you want it to be a DateTime field, just add a DateTime tool to convert it. Another thing you could do (if you just want the date and no time after, resulting in a field that is 2017-07-07) would be to just add a Select tool after your input and change the field type to 'Date'. Hope this helps!

All comments

Kenda

danrh

You should be able to use DateTimeParse([YourData],'%y-%m-%d')

Hope it helps!

adm510

Use a select tool and convert to Date, then convert back to DateTime

While this would work, I would use @danrh's formula

iRm

Thanks everyone! I used the Select tool and it was sufficient for my purposes.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703