Two of the columns in my table are the date of entry and the next column I
want to show the week number designated by that date. My date column is
named
installDate and the other column titled signWeek. in the signWeek default
value field and in it's format field I have been trying this code:
=FormatDateTime([installDate],"ww")
When placed in the default value I get an error: The database engine does
not recognize either the field 'installDate' in a validation expression,
or
the default value in the table 'contracts'
When placed in the format field this develops: first the text I entered is
reformatted into this: "=For"m"at"d"ateTi"m"e([i"ns"tall"d"ate],ww)" and I
get the same error as above about the database engine not recognizing
'installDate'.
I have verified over and over my spelling and field names?
Can someone explain to me the proper way to do this?
