Pervasive uses days from 1/1/1.
To convert from int to date use
new DateTime(1, 1, 1).AddDays(734360)
To convert to int using date use
TimeSpan t = (new DateTime(2011, 08, 11)-new DateTime(1, 1, 1)); int days = (int)t.TotalDays+1;
user159335
source share