2 Replies Latest reply: Sep 20, 2016 3:12 PM by Pim Jansen RSS

    IntervalMatch

    Christopher Ellis

      When using IntervalMatch does it matter how dates are formatted ?

       

      For example when I look at the data I have one that looks like this 07 September 2015 that I am checking to see if it exists between 2 dates that look like this 07-Sept-15.

       

      I have tried some formatting such as Date#("Date",'DD MMMM YYYY') and it does not seem to help.

       

      Any suggestions much appreciated.

       

      Chris