Date format in access

[cvaccess]

I am trying to export a table from Monarch to Access. The Date format prior to export is 26-Jun-2002. I need the same format as other tables which is 6/26/2002. How can I do this? Please help.

Thanks=)

cvaccess

 

[SgtJarrow]

Are you using an export command from Monarch or an import command from Access???

If you are working from Access, you can use the following:
Format(enterdatevaluehere, "Short Date&quot

If you are using Monarch, I can't help ya.... It's not important that someone else can do in one step what it took you ten to do...the important thing is that you found a solution.

Robert L. Johnson III, A+, Network+, MCP
Access Developer/Programmer

 

[cvaccess]

The user exports from Monarch but I did try importing from Access and it worked. I'll just have the user import into the database. Thanks for the help.=)

cvaccess