Re: [MSAccessProfessionals] Access 2007 issue

Did you try without setting the default value?

Duane

Sent from my mobile

On Jul 30, 2021, at 9:29 PM, cash.ghwa@gmail.com wrote:



I am having a hard time adding a new field – "Date Input" to an existing file "Patterns".

 

I have successfully created this field in another database "Inventory" years ago, and it works great!  So I thought I would add that type field to "Patterns".  But all I get is an error .  I create the new field as a Date/Time field with these specs and get the message shown when trying to save the change to the database. 

 

It is driving me crazy.

 

<AE9CDBD4A2CF406E97EA45DAE8782856.jpg>

 

I have tried using several Date functions – each comes back with the same Unknown function 'Date' error.

 

Can you help, please.  THANK YOU SO MUCH. 

 

Carol Higbee