> i am trying to get my head over the first digit only. would 1 = 20 and 0 = 19
Not exactly. Look at the first 2-3 digits. 1xx = year 20xx and xx = year 19xx 1011231 = 2001-12-31 790407 = 1979-04-07 Just do a few calculations by hand using various dates and the formula pasted below, and you will see the relationship. --- In [email protected], "murthysuresh" <mo...@...> wrote: > > i am trying to get my head over the first digit only. would 1 = 20 and 0 = 19 > > the first 2 digits of the year in YYYY format? > > --- In [email protected], "ozzyapeman" <zoopfree@> wrote: > > > > e.g. > > > > 2001-12-31 = 10000 * (year - 1900) + 100 * month + day = 1011231 > > > > > > > > > > --- In [email protected], "murthysuresh" <money@> wrote: > > > > > > i have a datenum like 1090403 > > > > > > what does the first digit stand for? > > > > > >
