Sorry if this has been asked before, searching for it multiple ways returns all kind of unrelated results.
I have one VBA project that consistently returns 1/1/1900 for "Date". I could have two projects open, with Project A in focus, type ?date in the Immediate window and get a return of 8/10/2021, with Project B (for bad) in focus, type ?date and it returns 2 (1/1/1900). Is there a project specific setting, a reference, or something else that would cause this?
Background: using date picker by Trevor Eyre and would like the it to open and display this month (August 2021) rather than January 1900. It uses today's date to set the month showing on open.
Thanks,
Doug
I have one VBA project that consistently returns 1/1/1900 for "Date". I could have two projects open, with Project A in focus, type ?date in the Immediate window and get a return of 8/10/2021, with Project B (for bad) in focus, type ?date and it returns 2 (1/1/1900). Is there a project specific setting, a reference, or something else that would cause this?
Background: using date picker by Trevor Eyre and would like the it to open and display this month (August 2021) rather than January 1900. It uses today's date to set the month showing on open.
Thanks,
Doug