Please help me with a query that pulls all the dates+time from a datatime field. This dattime field is called timesheet.
I have to pulls all the datetime date from this timesheet field that fall between present(curent or right now) date and time and yesterday, that is --- NOW( date + time) minus 24hrs.
The data in timesheet field looks like this:
1/20/2005 9:00:00 AM
Please help me with the correct quesry to get the right data.