convert number field with year value to date field



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.


Douglas J. Steele

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question