CVdate(int([<date/time>])) Not parsing

[EXCEL_Guy]

I have a date/time field that I need to query. But, the autotime stamp creates a field that looks like:: 6/17/2003 4:23:01PM. I need to query for the WHOLE day, but the criteria:: LIKE [<time/Date>] & * isn't working. This seems to be because ACCESS can't parse the time.

So, I researched MS and found CVDate(Int[<time/date>])) as a work around. I set a new field expression:: Expr1: CVDate(Int[<time/date>])) and now the SQL is barfing. It sez I have to many closing parathesis'.

What is Up With THis?...

HOW do I Parse the TIME off of my simple access select query??

Toad

Ref ::
http://support.microsoft.com/defaul...port/kb/articles/Q149/9/45.asp&NoWebContent=1

 

[mdmilner]

You do have too many parenthesis.

Change:

Expr1: CVDate(Int[]))

To:

Expr1: CVDate(Int([]))

 

[EXCEL_Guy]

Thanks, I saw that...

Here's what I got to work, ADD the table to the expr1::
Expr1:CVDate(Int(

.[<time/date>])) and left the TABLE cell empty.


Hope this helps future time/date parsers


Toad