Calculate Work Weeks

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

Trying to get the following to work but I keep getting error. 


If(not IsNull([FGCC Sign Off]), null, Days(WeekdaySub(Todate([Site Start Date]),Todate([FGCC Due]))))


Unfortunately I cannot change the field type of dates as apparently I need date/time fields.  Is there a type conversion available? 

Photo of Arshad Khwaja

Arshad Khwaja

  • 3,152 Points 3k badge 2x thumb

Posted 3 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 65,542 Points 50k badge 2x thumb
what field type is this?  Is this a formula Duration field type?
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,152 Points 3k badge 2x thumb
Sorry, should have said. Yes it is.
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,152 Points 3k badge 2x thumb
Another question is to  how to change smart units to say weeks?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,542 Points 50k badge 2x thumb
.. and what is the error message, and also are all three fields which are used in the formula date/time fields?
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,152 Points 3k badge 2x thumb
All date field are dates only.  I think I managed to get this working. Great if I could get weeks next to the number.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,542 Points 50k badge 2x thumb
Why don't you make this into a formula numeric field called [xxxxx Weeks]
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,152 Points 3k badge 2x thumb
I have field name accordingly but I would like to show weeks listed as part of the number. Just as smart unit show days with the number.