Formula help (Start date + number of days)
Hey everyone, 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 a...
Forum Discussion
So I attempted to make new formulas to (-1) for my Calendar alone, and now i'm just running into the same problem except on the calendar. My calendar now wont display anything under 1 day because they result in 0 or -1. is there any changes I can make to the formula to fix this?
New Formula Ex. Created on Schedules side:
Duration Code on Calendar side:
------------------------------
Alex Bennett
------------------------------
New Formula Ex. Created on Schedules side:
(ToText(Ceil([7. Sub Duration]/8 -1) & " " & "Days"))Duration Code on Calendar side:
ToNumber(Left(Case([Department - Phase], "Fixtures - Sub Rough", [Schedule - Fixtures Sub Duration(Calendar)], "Fixtures - Rough", [Schedule - Fixtures Rough Duration(Calendar)], "Fixtures - Finish", [Schedule - Fixtures Finish Duration(Calendar)], "Fixtures - Close", [Schedule - Fixtures Close Duration(Calendar)]), " " ))------------------------------
Alex Bennett
------------------------------
Is there a way to convert a Date field to Workdate? I'm attempting the WeekdayAdd function, but my start date is just the field type date. On the formulas page it says it can be used with Workdate as well? This sounds like my issue as having WeekdayAdd(WorkDate d, Number n) Sounds like it will include the start date as the duration. As WeekdayAdd(Date d, Number n) which I'm currently using, does not. I'm just not sure how to change the type to Workdate in my start date fields. Maybe Formula - Date, and add a certain formula to do so?
------------------------------
Alex Bennett
------------------------------
------------------------------
Alex Bennett
------------------------------
- Nevermind, found the problem in my process and made some changes to different layers of code.
Thanks Mark.
------------------------------
Alex Bennett
------------------------------