Is it maybe possible that in addition to a date being stored in that number that maybe also the time (or some form of time) is recorded in that number?





>Ian,
>
>Ok this isn't a linear function as in offset from some particular day zero. So it seems to be some sort of ymd encoding. Can you give us a table of these dates?
>
>d/m/y
>01/01/2005
>02/01/2005
>03/01/2005
>31/01/2005
>01/02/2005
>01/03/2005
>01/12/2005
>31/12/2005
>01/01/2006
>01/01/2007
>
>>i'll give you 2. These are 1 month apart
>>
>>131,402,758.00 is 06/12/2005
>>
>>131,466,478.00 is 06/01/2006
>>
>>Hope this helps