Separate part of a timestamp

[#1]

Hello,

I was wondering if someone has a solution to separate the date and hour from a timestamp ("DD.MM.YYYY hh:mm")?!

Instead of "01.01.2009 03:54" I'd like to generate "01.01.2009 03"

I was thinking of using the makedate function somehow...

Any suggestions?

[#2]

Hi Droz,

Do you wanna just omit the minutes?. I'm thinking this, based on your example "01.01.2009 03".

Best regards.

[rwunderlich · Accepted solution]

Yes, I think you are on the right track. Something along the line of :

Floor(timestamp(value, 'MM.DD.YYYY mm:ss')) + MakeTime(Hour(timestamp(value, 'MM.DD.YYYY mm:ss')) )

-Rob

[#4]

Dear Miguel and Rob - yes Miguel, that's it and Rob already found a solution that works 😉

Floor(timestamp(Value, 'MM.DD.YYYY hh:mm')) + MakeTime(Hour(timestamp(Value, 'MM.DD.YYYY hh:mm')))

Thanks a lot,

Nico