Forum Discussion
DATE/VALUE error with IF & OR statement
Hi everyone, I have an IF & OR statement te syntax is below and I am getting the following error "DAX comparison operations do not support comparing values of type Date with values of type Text. ...
Anonymous Please try this...
Result = IF(IFERROR(SEARCH("/",Test59StrDate[Enrollment],4),0)>0,IF(VALUE(FORMAT(Test59StrDate[Enrollment],"Short Date"))>=Test59StrDate[Outreach],"Yes","No"),"No")
Changing the two columns to text give me incorrect vales when (student enrollment >= date of outreach, "yes", "no" and keeping them both as dates still gives me the Value/format error...:(
Anonymous Please try this...
Result = IF(IFERROR(SEARCH("/",Test59StrDate[Enrollment],4),0)>0,IF(VALUE(FORMAT(Test59StrDate[Enrollment],"Short Date"))>=Test59StrDate[Outreach],"Yes","No"),"No")