convert number field with year value to date field

  • Thread starter Thread starter LVer
  • Start date Start date
L

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
 
The Date data type in Access cannot accept a date prior to January 1, 100.
 
Back
Top