Date format in queries

  • Thread starter Thread starter Derick Reinecke
  • Start date Start date
D

Derick Reinecke

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
 
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])


[email protected] said:
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
.
Click to expand...
Click to expand...
 
Back
Top