Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Round up timestamp

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

1 Solution

Accepted Solutions
CELAMBARASAN
Partner - Champion
Partner - Champion

Check with this expression

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

Hope it helps

Celambarasan

View solution in original post

2 Replies
CELAMBARASAN
Partner - Champion
Partner - Champion

Check with this expression

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

Hope it helps

Celambarasan

Not applicable
Author

Thanks for that