RE: Date format in queries

From: mb (mb_at_discussions.microsoft.com)
Date: 06/29/04 

Date: Tue, 29 Jun 2004 14:25:02 -0700

THanks a lot!! This is so helpful. Here is my query:

DATE APPLIED_VALUE: IIf([DATE] Is Not Null,DateValue(Format([DATE]," mm/dd/yyyy")),[DATE])

"anonymous@discussions.microsoft.com" wrote:

> You could try using the DATEVALUE function.
>
> >-----Original Message-----
> >Hi,
> >
> >In a query, I enter a date as an expression. (Date:
> [Enter the
> >Date:])I need to convert this to Date/Time format. For
> example, if I
> >enter "31/3/04" I get this as a Text value instead of
> 31/03/2004 in
> >Date/Time format.
> >
> >Does anyone have suggestions?
> >
> >Many thanks
> >
> >Derick
> >.
> >
>