4 Replies Latest reply: Dec 12, 2017 1:58 AM by Shamit Shah RSS

    Load data between 2 dates

    Shamit Shah

      Hi,

       

      I have the following the script which works fine:

       

      WHERE ([Shift Date] < Date('03/12/2017'))

       

      I want to now only load data between 18 Nov 2017 and 3 Dec 2017. I tried the following but it is coming up with an error:

       

      WHERE ([Shift Date] > Date('18/11/2017') AND [Shift Date] < Date('03/12/2017'))

       

      Any ideas?

       

      Thanks