Forum Discussion
Expression Error We cannot apply operator < to types DateTime and Date
Hi I keep the above error even after changing data type to Date for both columns. Trying to create a new custom column based on both columns date comparison.
Hi， Anonymous
I can reproduce the problem here.
As amitchandak said, you need to make sure the two columns are of the same DateTime/ Date type before creating the custom column.
You need to insert the step after ‘Changed Type’ rather than ‘Added Custom’.
Please check my attached pbix for more details.
Best Regards,
Community Support Team _ Eason
Hi， Anonymous
I can reproduce the problem here.
As amitchandak said, you need to make sure the two columns are of the same DateTime/ Date type before creating the custom column.
You need to insert the step after ‘Changed Type’ rather than ‘Added Custom’.
Please check my attached pbix for more details.
Best Regards,
Community Support Team _ Eason