5 Replies Latest reply: Feb 27, 2015 3:57 AM by Henco van Ee RSS

    Compare timestamps

    Henco van Ee

      Hi all,

       

      I would like to create a report with all orders which are created after a specific date and time.

      All orders have a created timestamp. I would like to see all orders which are created since 15:00 o'clock the day before today.

       

      I tried different formats, but I can't get it done. Could someone please explain which format I need to use for the following fields to compare them?

       

      • Oracle database field: createdate
      • Variable in QlikView: date of today minus 1 (to show yesterday) + 15.00 o'clock

       

      Many thanks!

       

      Kind regards,

      Henco