Round up timestamp

[#1]

Hello,

I have a field with timestamps, e.g. 20/12/2012 18:32:30 etc and if I use the hour function the previous example would give me 18. However for the purposes of my report I need to round this up so that it would be 19. So essentially anything that happens between 18:00:00 and 18:59:59 should have an hour value of 19 and not 18. Does anyone have a solution to this?

Thanks,

Ralph

[CELAMBARASAN · Accepted solution]

Check with this expression

=Ceil(Hour(TimestampField)&'.'&Minute(TimestampField)&Second(TimestampField))

Hope it helps

Celambarasan

[#3]

Thanks for that