create input mask "yyyy-mm-dd"

[Philly]

I am trying to convert the dates in my query from the format of mm/dd/yyyy to
yyyy-mm-dd and it is driving me crazy. They will not upload into another
registry if not in that format. I would appreciate ANY assistance.

 

[BruceM]

You want to format the date. The input mask is of limited use only for
entering data. At the top of a blank column in query design view you could
have something like:
NewDate: Format([YourDateField],"yyyy-mm-dd")
Use your actual date field name in place of YourDateField.
See Help for more information about the Format function.

 

[Marshall Barton]

I am trying to convert the dates in my query from the format of mm/dd/yyyy to
yyyy-mm-dd and it is driving me crazy. They will not upload into another
registry if not in that format. I would appreciate ANY assistance.

You can just set the field Format property to yyyy-mm-dd

But, it is a poor practice to use a query's sheet view to
display data. Much better is to create a form, even if the
form displays in datasheet view, and set the Format property
of the date field's text box.

 

[Carl_and_Earl]

You can just set the field Format property to yyyy-mm-dd

I tryed 2 days to find how to do that, thanks

"You can just set the field Format property to yyyy-mm-dd "

 

[John Spencer]

Open up the query in design view,
Click in the grid on the field
Enter the string in the Format property (right click to get properties
if they are not showing)

If you are working with the records on a form - which you should be.
In design view
-- Click on the control
-- In the control's format property, enter
dd/mm/yyyy

This does assume that the field is a dateTime field.

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