Compare dates in filter

Chris Harper

• September 08, 2021 21:00

How can I use an arbitrary date in the Argument #2 field for this filter expression? This produces an error message: "Message: Argument #2 for operation greaterthanequals is a different data type: string." I have selected Data Type "Date Time" from the settings box for Argument #2 with no luck.

0

• 

  Daniel P

  • September 22, 2021 15:10

  

  Courtney Jordan Is there a way to compare two dates (a last updated date and the current date/time for example) and get a difference in minutes in a filter? Much like the dateAdd in handlebars but for a filter?

  1
• 

  Courtney Jordan Experience Strategy & Design Director Community moderator

  • September 13, 2021 19:16

  

  

  

  Hi Chris Hunter,

  Sorry for the delay on this. We are looking into it to determine if this is an issue we need to fix. Will hopefully have this info by tomorrow. Thanks so much for letting us know that you've run into this issue, and please continue to let us know what else we can do to improve your experience!

  0
• 

  Courtney Jordan Experience Strategy & Design Director Community moderator

  • September 14, 2021 21:08

  

  

  

  Hi Chris Hunter,

  First, set your data type to Expression if you haven't already. To do so, click the gear icon next to the last field (hover to the right of the field to display it). 

  

  Then, set your filters like this:

  record.lastExportDateTime is less-than ["epochtime", "2021-09-07T00:00:000Z"]

  Please let us know if that works for you! Thanks!

  0
• 

  Tom Santiago Principal Technical Writer Community moderator

  • October 07, 2021 19:23

  

  

  

  Hi Daniel P,

  Filter syntax via the filter editor is very limited and uses a cumbersome syntax:

  https://docs.celigo.com/hc/en-us/articles/360025927811-Apply-filters#Supportedexpressions

  Orion Abrams (one of our Senior Engineers), suggested you instead use a preSave page hook and use something like this to get what I think you are looking for:

  function preSavePageFunction(options) {
      const records = options.data;
      for (let i = records.length - 1; i >= 0; i--) {
          let dataRec = records[i];
          //add date comparison here
          if (dataRec.dateModifiedByUser) {
              let date1 = new Date(options.lastExportDateTime);
              let date2 = new Date(dataRec.dateModifiedByUser);
              if (date2.getTime() < date1.getTime()) {
                  options.data.splice(i, 1);
              }
          }
      }
      return {
          data: options.data,
          errors: options.errors
      }
  }

  0

Please sign in to leave a comment.