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
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?
.. 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.
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.