7 Replies Latest reply: Feb 7, 2018 8:33 AM by beck bakytbek RSS

    records with field: audit_time

    beck bakytbek

      Hi Folks,

       

      i have q question: I have following records with field: AUDIT_TIME, and field: AUDIT_TIME does look like: 06.02.2018 18:18:57

      test_Field, audit_time

      1, 07.02.2018 18:18:57

      2, 06.02.2018 18:18:55

      3, 05.02.2018 07:18:15

       

      my question is: how can i compare or select the only records that have been reloaded today or yesterday? can i use in scriptarea the function: Today () to see only new records (records that have been reloaded today) ?

       

      for instance: i want to see only the record:

      1, 07.02.2018 18:18:57 for today

      or

      2, 06.02.2018 18:18:55 for yesterday

       

      Thanks a lot for any feedback and help

      Beck