Query for date

[okl]

Hi there,

I have a table with a date field "ETB" in ddmmyyyy hh:mm:ss

How can i do a query to extract out the data that is 2 days ago for eg. 22/08/2015 23:59

I set auto schedule to run the query weekly on monday 06:00, but i do not want the latest data.


Thanks

 

[ranman256]

'find those 2 days prior today
select * from table where [ETB] = dateadd("d",-2, Date())\

'find those 2 days prior given date
select * from table where [ETB] = dateadd("d",-2,"22/08/2015")

 

[okl]

'find those 2 days prior today
select * from table where [ETB] = dateadd("d",-2, Date())\

'find those 2 days prior given date
select * from table where [ETB] = dateadd("d",-2,"22/08/2015")

If i run the query on today 06:00, but i want it to be 22/08/2015 "23:59" not 06:00