If I use the type 'date' in a formula, with a comparison eg
[Duedate] < datetimeadd( [Quarter] , 3, 'months') // where [Duedate] and [Quarter] are both 'date' types
this doesn't behave as expected for eg
| Quarter | Duedate |
| 2016-01-01 | 2016-04-01 |
| 2016-01-01 | 2016-04-02 |
-> neither of these are due in the quarter, but if the fields have type 'date' , the top one will evaluate as 'true'
whereas if they have type= 'datetime', they will both be false.
also if I use the following formula then it will be correct: datetimetrim([Duedate],'day') < datetimeadd( [Quarter] , 3, 'months')
why is this? (it causes unexpected behaviour and is very hard to find the cause)
