Hmz,
I have only tried the '0 date' in excel where 1 = 1-1-1900
In access 1 = 31-12-1899
And then SQL Server where 0 = 1-1-1900
Then Oracle and unix that do it different again... It is a wonder that all these systems can work "together" at all.
Bob and I have 'butted heads' in the past as well. Tho my visiting the forum is on and off depending on "other responsibilities" I do try to keep it up.
CU Around.
only now see your sig. Wow MVP Cool man
CU Brent
I have only tried the '0 date' in excel where 1 = 1-1-1900
In access 1 = 31-12-1899
And then SQL Server where 0 = 1-1-1900
Then Oracle and unix that do it different again... It is a wonder that all these systems can work "together" at all.
Bob and I have 'butted heads' in the past as well. Tho my visiting the forum is on and off depending on "other responsibilities" I do try to keep it up.
CU Around.
only now see your sig. Wow MVP Cool man
CU Brent