I receive ‘inconsistent data types’ when subtracting a lookup date column from a date column present in the table. What workaround can I employ to get it working?
First off, please use the dateadd()/datedif() function when working with dates. {Date1} - {Date2} is unlikely to give you the right result.
Second, the result type in lookup columns is “array” (even if only one value is looked up). You cannot perform computations on results of type array. (This may be changed in the future.)
In version 3.0, subtracting a lookup date column from a date column will be supported. The first entry in the lookup column will be used.
2 Likes
