Am just trying to set the default value (on the form, not programmatically) of a text box to a date but with every attempt it either fails or sets the date to 1905-randmon month & random day.
I've tried a few different methods from various online sources... feeling like a newb here...
=Now() works fine.
Any attempt to set to an actual date returns 1905-Random Month-Random Day ?!?
I am trying to set it to the 1st day of the current month.
Text Box is formatted as Short Date - Regional settings are set to the ISO standard numeric date format YYYY-MM-DD.