Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi Ryan,
Try something like:
WHERE neighbourhood = 'Liberty Village' AND
Date#(Left(billing_date, 10), 'YYYY-MM-DD') < Today();
Hope it serves,
Regards,
H
Hi Ryan,
Try something like:
WHERE neighbourhood = 'Liberty Village' AND
Date#(Left(billing_date, 10), 'YYYY-MM-DD') < Today();
Hope it serves,
Regards,
H