Hi Philp,

When dates are stored as numbers, that number usually represents number of days (or minutes or seconds) from the base date. To find the base date you can create a record with known date and try to play with it using DATEADD() function.

>Hi,
>I'm looking at an sql server application which stores dates as iintrgers eg 54050400.
>I haven't got access to any of the code that manipulates the data. Can anyone tell me how the dates might have been converted to integers so that I can work out how to read them.
>
>
>Phil.