Question Locked

Access mde default date() function

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have several Access forms in an mdb that displays the default date(). They work fine in the mdb but when I create a mde for distribution to a PC without Access, the forms don't display the date but show instead #Name in the field. I reviewed the date() function in Help which indicates it is the system date which I assume is the PC date. The PC date is displayed and is correct. Does anyone know what is going on with this date?

2 replies

by mikealparfrey

Have you tried to use the now() function? You may need to format the date to get the display format you want. You can use the format() function to return the date as a string.

This discussion is closed to new replies.