I can't get WeekDaySub to work. Getting "Formula error -- Bad or missing arguments in function call".

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
Trying to show Lead Time based on ticket creation date and due date using WeekDaySub function, I get "Formula error -- Bad or missing arguments in function call". What am I doing wrong?

WeekdaySub([Due Date], [Date Created])


Photo of Jason

Jason

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,280 Points 50k badge 2x thumb
The [Date Created] field is actually of type Date / Time, notew a date field type.  So we need to convert it to be a date.



WeekdaySub([Due Date], ToDate([Date Created]))
Photo of Jason

Jason

  • 0 Points
Ah, that makes sense - and it worked! Thank you!