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
MarkShnier__You
Qrew Legend
Qrew LegendI suggest that you have one field to calculate the duration in days for display purposes and then use another formula to calculate the end date for the calendar. The latter will have the minus 1.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
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
------------------------------- Nevermind, found the problem in my process and made some changes to different layers of code.
Thanks Mark.
------------------------------
Alex Bennett
------------------------------