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


    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.