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
1 Answer
-
Jan 24 at 08:55 PM
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")
Add comment
Add comment