Find & Replace

[Brianwarnock]

You have to realise that 00/01/1900 is not a date, you cannot have a day number 00; 00/01/1900 is the day of the "big bang" according to Microsoft ,

so whilst I am not privey to the inner workings of Microsoft's software I am not surprised that this does not behave like a date, therefore treat it like the number it is stored as , namely 0.0

Brian

 

[shades]

Well, in MS thinking all dates are serial numbers, today 02/13/2008 is actually 39491. 01/01/1900 is day 1. Therefore, 00/01/1900 is day 0. Hence the result.
________
RANGE ROVER

 

[pl456]

makes sense now you put it like that.

Cheers