Date format

[Falcon08]

How do I format the date to "08/08/2008" instead of "8/8/2008"?

 

[Biatch84]

Hello

You change this in the control panel, under Regional Settings.

 

[KARL DEWEY]

In your query for the form or report use this --
My_Date: Format([YourDate], "m/d/yyyy")

 

[John Spencer]

Karl,
Close ;>)

My_Date: Format([YourDate], "mm/dd/yyyy")

Or apply that format using the controls format property.

Of course, we don't know if the user meant this instead of the above.
My_Date: Format([YourDate], "dd/mm/yyyy")


John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

In your query for the form or report use this --
My_Date: Format([YourDate], "m/d/yyyy")

How do I format the date to "08/08/2008" instead of "8/8/2008"?

 

[KARL DEWEY]

I, like many others, response to what I thought I read.
--
KARL DEWEY
Build a little - Test a little

Karl,
Close ;>)

My_Date: Format([YourDate], "mm/dd/yyyy")

Or apply that format using the controls format property.

Of course, we don't know if the user meant this instead of the above.
My_Date: Format([YourDate], "dd/mm/yyyy")


John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

In your query for the form or report use this --
My_Date: Format([YourDate], "m/d/yyyy")

How do I format the date to "08/08/2008" instead of "8/8/2008"?