Hi,
I am trying to report number of days between today and query open date to make sure that they are less than or equal to 10 days. I am trying to use the following formula but it gives me #MULTIVALUE error. Please help.
=If DaysBetween(ToDate([Query Open Date];"DD/MM/YYYY");ToDate(CurrentDate();"DD/MM/YYYY"))<=10 Then Count([Query Status Name];All) Where([Query Status Name]="Open" And [Marking Group Name]="Site")
Regards,
Tejas Shah
currentdate() is already date data type.there is no need of to use todate() again.todate() is required if date object datatype is string. Check for query open date object data type.if it's date then remove to date from there also.
Other than that use format "dd/MM/yyyy" if date type is string.
Or try this.
=if DaysBetween([Query Open Date];CurrentDate())<=10 Then Count([Query Status Name];All) Where([Query Status Name]="Open" And [Marking Group Name]="Site")
Thank you Amit for your prompt answer.
I tried you using the one suggest by you however I am still getting #MULTIVALUE Error.
Regards,
Tejas Shah