Skip to Content

#MULTIVALUE Error while using Days between formula

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

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
    10|10000 characters needed characters exceeded

    • 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