how to formate date in to mm/dd/yyyy

Question

how to formate date in to mm/dd/yyyy

thep1 (IS/IT--Management)

(OP)

9 Jul 18 17:40

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 (Programmer) · Answer 1 · 2018-07-09 18:31:43

You may try:

Format(CDate(Left([F7], 10)), "mm/dd/yyyy")

---- Andy

There is a great need for a sarcasm font.

thep1 (IS/IT--Management) · Answer 2 · 2018-07-09 19:00:23

RE: how to formate date in to mm/dd/yyyy

thep1 (IS/IT--Management)

(OP)

9 Jul 18 19:00

Thanks Andrzejek… that works.

dhookom (Programmer) · Answer 3 · 2018-07-09 21:15:58

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

Come Join Us!

Posting Guidelines

Jobs

how to formate date in to mm/dd/yyyy