Don’t use = operator on Date values

Don’t use = operator on Date values

Date variables store values in floating point format, much like Double variables, with the integer part for dates and the fractional part for the time portion. Being floating point values, Data values may be subject to rounding problems, and for this reason you shouldn’t test two Date variables for equality using the “=” operator.

Instead, use the DateDiff function, or evaluate the difference between the two values and check that it’s less than a very small value, as in:

If Abs(Date1 - Date2) 


Share the Post: