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,