Script where clause

[stephenedberkg]

i have a date field like 2015-07-28 11:00:00.000

I want to load the date 2015-07-28 11:00:00.000 to 2015-06-28 11:00:00.000

how to achieve this in where clause?

thanks In advance

[jonathandienst]

Use this where clause:

Where DATE >= Date#('2015-07-28 11:00:00', 'yyyy-MM-dd hh:mm:ss') And DATE <= Date#('2015-06-28 11:00:00.000', 'yyyy-MM-dd hh:mm:ss')

But note that if the DATE does not contain time values (as in your sample), then this will not load data for 28 July 2015 and the first date will be 29 July.