F
Frank Meulblok
Guest
The fact that the "1 - today" doesn't work probably should be reported as a Tech Support case. There's 2 implicit data type conversions here: from date to integer to resolve the expression, and then back from integer to date for the variable assignment. If the other variants support the implicit data type conversions to make this work, there's no reason this one shouldn't so this can be considered a defect. I'll second gdb390's suggestion to use add-interval for any time-based calculations though. That keeps the intent clearer in my eyes.
Continue reading...
Continue reading...