convert number field with year value to date field

[LVer]

Is it possible to convert a number field containing years (possitive and
negative) to a date field. It does not matter if they turn out all being the
1st of january. I just have an historical database with the year values bc
and ad stored as negative and possitive numbers and want to convert them to a
date of the format mmm dd yyyy.

thanks,
LVer

 

[Douglas J. Steele]

The Date data type in Access cannot accept a date prior to January 1, 100.