Loading data with date range and where clause

[#1]

I'm trying to load data from an excel file with a where clause that include filtering by a field as well as within a certain date range.  The fields I'm using are 'neighbourhood' and 'billing_date' where billing_date is in the following timestamp format: 2010-08-01 00:00:00.000000 -04:00

How might I do this in the load script where the neighbourhood matches a specific value such as 'Liberty Village' and I'm pulling in data where the  billing_date is less than today?  The file I have has transactions written for the rest of the year.

[hector_munoz · Accepted solution]

Hi Ryan,

Try something like:

WHERE neighbourhood = 'Liberty Village' AND

              Date#(Left(billing_date, 10), 'YYYY-MM-DD')  < Today();

Hope it serves,

Regards,

H