An old date.

[nnadimi19]

Good Morning Folks;

I have a spread sheet that has some dates in one of the columns. I am having a problem converting any date before 1/1/1900 to the format below.:
yyyy-mm-dd hh:mm:ss.000

I need this format because I need to populate another DB with this information. I cannot put "" when converting because the DB is expecting a date and not a text field. Any help with this issue will be really appreciated.
ray: ray: ray: ray:

 

[BrianB]

I suggest you do a Google search on "Excel dates before 1900".

Here is something pretty definitive :-
http://www.j-walk.com/ss/excel/usertips/tip028.htm

 

[nnadimi19]

THANK YOU, THANK YOU