access2010
Registered User.
- Local time
- Today, 08:21
- Joined
- Dec 26, 2009
- Messages
- 1,021
Up until to-day, the date entry was always correct
We use a Macro SendKeys; =Format$(Date(),"yy mmm dd")
Wait; No
The Field Format is; yyyy mmm dd
I also tried the Field Format as; yy mmm dd
Using the macro for either format the entry appears as; 21 Apr 04
When we leave the field the entry appears as; 2004 Apr 21
The Windows 10 date reads; 4/4/2021
Can I please have a suggestion how to fix this problem, which for the FIRST time appeared to-day?
Thank you
Nicole
We use a Macro SendKeys; =Format$(Date(),"yy mmm dd")
Wait; No
The Field Format is; yyyy mmm dd
I also tried the Field Format as; yy mmm dd
Using the macro for either format the entry appears as; 21 Apr 04
When we leave the field the entry appears as; 2004 Apr 21
The Windows 10 date reads; 4/4/2021
Can I please have a suggestion how to fix this problem, which for the FIRST time appeared to-day?
Thank you
Nicole