Forum Discussion
Comparing two dates when one field is text and the other a date
Hello I'm hoping someone can help. In my data I've got two different fields. An opened date and a closed date. My opened date always contains an date so the format is date. The closed date doesn'...
My bad.
Try the following:
IF(Or(not((opened_date)=(closed_date)), IsBlank(closed_date)),0,1)
Regards,
Michael
Thanks Michael. That cleared that error but I still get the following:
DAX comparison operations do not support comparing values of type Date with values of type Text. Consider using the VALUE or FORMAT function to convert one of the values.