troubleshooting Question

How to pick the date format as Short Date (dd/mm/yyyy) without the Time in it to be pulled in an Expression?

Avatar of Issa S.
Issa S. asked on
Microsoft Access
6 Comments5 Solutions113 ViewsLast Modified:
Hi,,,

How to pick the date format as Short Date (dd/mm/yyyy) without the Time in it to be pulled in an Expression?

Although it is formatted on the form as Short Date, I still get the time with it when I build an expression for another Text Box in the same Form.
Also, It is defined in the underlying table as Date/Time formatted as Short Date !

I am interested in dd/mm/yyyy  or  mm/dd/yyyy only for the sake of the table and the Form Expression.

Thanks a lot.
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 5 Answers and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 5 Answers and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros