2 Replies Latest reply: Jan 14, 2013 10:07 AM by Ralph Graham RSS

    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