Avatar of Issa S.
Issa S.

asked on 

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

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.
Microsoft Access

Avatar of undefined
Last Comment
Issa S.

8/22/2022 - Mon