Forum Discussion
- ChrisChrisQrew Assistant CaptainIs your formula field a numeric data type? I believe WeekDaySub yields a numeric value.
- NoelleDivinagraQrew TraineeI have a Duration field type. I also have this formula Today() - [Date in Pipeline] but it doesn't exclude weekends. _
- QuickBaseCoachDQrew CaptainSee 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]) - NoelleDivinagraQrew TraineeHello!
I tried that formula but it gave me an error saying "Expecting duration"
- ChrisChrisQrew Assistant CaptainYou may have also wrapped ToDATE() around a regular date field. You don't need to do that.