I have a query where I need to calculate the number of days from January 1st 1960, based on the data pulled.
December 31 1959 = -1
Janurary 2nd 1960 = 1
I have tried the DateDiff ('d', 01/01/1960, [tablename].[date]) , but this doesnt seem to work properly...