how to formate date in to mm/dd/yyyy
how to formate date in to mm/dd/yyyy
(OP)
I have field in DB that stores date in this format:
2018-07-02-00.00.00.000000
I would like have it format to 07/02/2018
tried this Exper1: Format([F7],"mm/dd/yyyy") but still shows in the above format.
2018-07-02-00.00.00.000000
I would like have it format to 07/02/2018
tried this Exper1: Format([F7],"mm/dd/yyyy") but still shows in the above format.
RE: how to formate date in to mm/dd/yyyy
Format(CDate(Left([F7], 10)), "mm/dd/yyyy")
---- Andy
There is a great need for a sarcasm font.
RE: how to formate date in to mm/dd/yyyy
RE: how to formate date in to mm/dd/yyyy
It's a good idea to mark a "Great Post" so that others know the question has been answered. This also gives some credit to the person who provided the solution.
Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016