2 Replies Latest reply: Mar 28, 2012 6:33 AM by luqsul275 RSS

    Can you add an integer to the result of a date and time function?

      The script below returns the values (intergers) 1-24

      Hour (`date_entered`)
      

       

      How do I add the integer value '1' to the result. I wanted the script below to display something like '07:00-8:00'

      Here's what I tried:

      Hour (`date_entered`) & ':00' & '-' & Hour (`date_entered` + 1) & ':00' as Hour,

       

      Can anyone help?