And what is the calculation?
this is my calculation:
If ( not ( IsEmpty ( UAT Date )) ; 5 * Int ( ( UAT Date - UAT Starting Date ) / 7 ) +Middle ( "0012345501234544012343340123223491111234010012340" ; 7 * (DayOfWeek ( UAT Starting Date ) - 1 ) + DayOfWeek ( UAT Date ) ; 1)+1)
Are you trying to compute the number of elapsed days from UAT Starting Date to UAT Date? Are both of these fields of type date?
If so, just use
UAT Date - UAT Starting Date
and you will get the number of days.
Thank you for your post.
My calculation does the average working days:
"If (IsEmpty (( UAT Date ) ) ; 5 * Int ( ( Get(CurrentDate) - UAT Starting Date ) / 7 ) +Middle ( "0012345501234544012343340123223491111234010012340" ; 7 * (DayOfWeek ( UAT Starting Date ) - 1 ) + DayOfWeek ( Get(CurrentDate) ) ; 1 ) +1)"
I resolved the issue with the number 10. But the fields only get calculated when i add the date. But the field does not recalculate every day. For example the start date is 01.01.2011 and the end date is 01.03.2011. I expect the result is 3 including the start date. But when i look at the calculation one day later, the number remains 3 unless i re-enter the starting date. Then it displays 4. How can i ensure that this is done automatically every day?
when a calculation gets a value from a Get( ) function, most of times it needs to be an UNSTORED calculation.
( Look at "storage options..." on the bottom right of the calc window )
Thank you very much, in my test scenarios this has proved to be the solution. !! :-)