01-11-2019 10:22 AM
I have a table with one field that is number of days in it (decimal). I want to add this to a calendar date (01/01/1970). I have researched all options and am doing something wrong as each effort results in an error.
As close as I have been able to get is
[T1] = 17905.72715 This is the number of days since 01/01/1970
The error returned is "Expression Error: The number is out of range of a 32 bit integer value. Details: 17905.72715
Thanks for advice.
Solved! Go to Solution.
01-11-2019 12:55 PM
Is there another function that will accept decimal values? The resulting value would represent intraday prices and eliminating the decimal portion would result in an inaccurate value.