how to formate date in to mm/dd/yyyy 1

[thep1]

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.

 

[Andrzejek]

You may try:
[tt]
Format(CDate(Left([F7], 10)), "mm/dd/yyyy")
[/tt]


---- Andy

There is a great need for a sarcasm font.

 

[thep1]

Thanks Andrzejek… that works.

 

[dhookom]

thep1,
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