Jose C
asked on
Converting date time
how do i convert
7/12/2000 3:11:36 PM to 07-12-2000
or
10/25/2000 2:02:29 PM to 10-25-2000
the basic requirements being 10 characters and dashes as dividers
using access 2000 at the moment and preferring a Query
thanks!
7/12/2000 3:11:36 PM to 07-12-2000
or
10/25/2000 2:02:29 PM to 10-25-2000
the basic requirements being 10 characters and dashes as dividers
using access 2000 at the moment and preferring a Query
thanks!
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
format(#7/12/2000 3:11:36 PM#,"mm-dd-yyyy")