How do I convert date input to mm/dd/yy

[Guest]

users input 1/1/80 or 1-1-80 I need to convert to 01/01/80 (mm/dd/yy) to use
in another database

 

[Rick B]

Dates are stored as a number that represents the number of days past since a
set point in time.

You can display the date in any format you desire in your queries, reports,
and forms using the "format" command. See help for more details.

 

[Guest]

One easy way to make sure your users type the format you want is to use an
input mask. To do this for a form:

If you right click the correct object (where the users enter the data),
select the "Data" or "All" tab and look for input mask. Click in the empty
box next to it, then click the box with the three dots. Select the correct
input mask. When your user goes to enter the date, this will show them the
proper format you want.

To do this for a table:

Go into the design view of the table, then click on the appropriate field.
Click into the empty box next to input mask, then click the three dots and
select the appropriate input mask. Hope this helps!

--
Have a nice day!

~Paul
Express Scripts,
Charting the future of pharmacy