I have a table which contains a date column called installDate in the next
column I want the date to appear as the week of the year that would be,
that
column is called weekNum. I have been trying to accomplish this in various
ways. The date column is ofcourse a date data type but I'm not sure which
data type the weekNum should be. I have been using the following formula
in
various fields of weekNum, including the format field and the default
value
field.
=FormatDateTime([installDate],"ww")
When I use this code 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'.
(Which
is the name of my table)
Any help would be greatly appreciated!
