I'm having an issue getting my formulas to display on a Calendar report correctly. The start date is never 'included' in the count of days for the job duration, so on the Calendar I always get an extra day added. I only know that I could add -1 to the formula to minus a day, but then if that value is 0 because it has no duration, it gives me a -1... or if the result is only 1 day for the job, right now it will display 2 days on the calendar, if I add a -1, the duration will change to 0 on my form. Is there any work around to this? Kind of annoying that the start date isn't included in the count.
Formula:
(ToText(Ceil([1. Sub Duration]/10) & " " & "Days"))//
[1. Sub Duration] is my previous step that gets the final number in hours in a Numeric - Formula Field, divided by 10 for 10 hour workdays.// Then obviously to result in # Days to display on the form for readability.
Any help would be appreciated.
Thanks!
------------------------------
Alex Bennett
------------------------------
