Is it possible to change a date format from:
yyyy-mm-dd 00:00:00 to mm/dd/yy
in a query? And also to have the today's date in the field if the field is empty?
The data is linked to an Excel file so I'm not able to make changes from within Access. So would that prevent the query from changing the format or data in the field prior to placing it in a new table?
yyyy-mm-dd 00:00:00 to mm/dd/yy
in a query? And also to have the today's date in the field if the field is empty?
The data is linked to an Excel file so I'm not able to make changes from within Access. So would that prevent the query from changing the format or data in the field prior to placing it in a new table?