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

    Load data between 2 dates

    Shamit Shah



      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?