Good morning sr.
The production table which I used in this query to get the most 2 recent dates, is a query from SQL Server (I am only guessing, since the production query is written by someone else).
The date field in the production query contains the time portion, as a result some of the records are showing the same date twice. e.g.
5005 10/5/2012 3:29:33
5005 10/5/2012 3:29:15
How do I tell the query to ignore the time portion, so it can pull a different date instead? for example like the one here shown below.
5005 10/5/2012 3:29:33
5005 10/4/2012 13:20:15
I've tried to remove the time portion by using differrent format functions like FormatDateTime, CDate, DateValue... it does not work but generated an ODBC-Call failed #195 error.
Thanks
Phucon
|
|
|
| ||||
|
|
| |||
|
|
|
| ||
|
| ||||
|
|
| ||
|
|
|
| ||
|
|
|
|
Posted by: saigonf7q5@yahoo.com
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (5) |
Tidak ada komentar:
Posting Komentar