This content has been marked as final. Show 2 replies
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?