DBA (5/5/2009)
sorry i edited29
29
62
677
677
[font="Verdana"]That looks like the number of days from 1900-01-01. So your conversion will be something like:
datediff(day, '19000101', MyDate)
...where MyDate is the name of the column containing the datetime value.
[/font]