Load data between 2 dates

[shamitshah]

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

[Chanty4u · Accepted solution]

try this

where [Shift Date]>Date('18/11/2017') and [Shift Date]<Date('03/12/2017');

[Chanty4u]

or try this

try this

where [Shift Date]>'18/11/2017' and [Shift Date]<'03/12/2017';

[devarasu07]

Hi,

try like this,

let hDate = date('18/11/2017','DD/MM/YYYY');

let dDate = date('03/12/2017','DD/MM/YYYY');

Fact:

load * from table

where date([Shift Date])>=date('$(dDate)') and date([Shift Date])<=date('$(hDate)');

Thanks,

Deva

[shamitshah]

Thanks,

That worked out.

[mv]

and what if we need the same day each year 

let hDate = date('15/11/2018','DD/MM/YYYY');

let dDate = date('24/12/2018','DD/MM/YYYY');

and I want select dates from each year between 15 November and 24 December

thanks m

.