Forum Discussion

NoelleDivinagra's avatar
NoelleDivinagra
Qrew Trainee
7 years ago

Calculate total number of days between today and [Date in Pipeline] excluding weekends.

Hello! I need help on this.

Calculate total number of days between Today and [Date in Pipeline] excluding weekends. 

I have the below formula, but I get an error message saying "Expecting text/datetime/workdate but found date"

WeekdaySub (Today(),ToDate([Date in Pipeline]))
Errors
Formulas and functions
  • ChrisChris's avatar
    ChrisChris
    Qrew Assistant Captain
    7 years ago
    Is your formula field a numeric data type? I believe WeekDaySub yields a numeric value. 


    • NoelleDivinagra's avatar
      NoelleDivinagra
      Qrew Trainee
      7 years ago
      I have a Duration field type. I also have this formula Today() - [Date in Pipeline] but it doesn't exclude weekends. _
    • QuickBaseCoachD's avatar
      QuickBaseCoachD
      Qrew Captain
      7 years ago
      See Chris's comment below. If the [Date in Pipeline] is just a date type field already, you do not have to try to make it a date field again.

      try this

      WeekDaySub (Today(),[Date in Pipeline])


    • NoelleDivinagra's avatar
      NoelleDivinagra
      Qrew Trainee
      7 years ago
      Hello!

      I tried that formula but it gave me an error saying "Expecting duration"

  • ChrisChris's avatar
    ChrisChris
    Qrew Assistant Captain
    7 years ago
    You may have also wrapped ToDATE() around a regular date field. You don't need to do that.