2012년 5월 7일 월요일 오전 4:10
Hi, Iam customising a text field to reflect what day an activity falls on. ie if a taskis dated for the 13th July then that would be Day 2. The below formula is what I have already. This works up to 8 IIF statements then fails there afterwards. Has anyone any ideas ? Are you only able to perform a set amount of IIF statements?
2012년 5월 7일 월요일 오전 4:39중재자
Try this instead:
"Day " & DateDiff("D","7/11/2012",[Start])
Im using the MM/DD/YYYY format so adjust if you use DD/MM/YYYY
2012년 5월 7일 월요일 오후 12:53중재자I would not be surprised to discover that Project has limitations on arguments, similar to Excel. You may be able to coax a few more options from a Switch statement but even then you are going to run out of options. Brian's suggestion calculates the day for you without all of the hassle of counting each day.
2012년 5월 7일 월요일 오후 1:45
>> "Day " & DateDiff("D","7/11/2012",[Start])
This is a good solution. I agree with Julie.
IMO; the limits are not documented in Project help pages or in any other place. Project has similar functions but the limits are quite different than that of Excel and Access. Limits may further change, depending on the length of strings used in expressions. We need to find out by testing.
I would also suggest you read Jim Aksel's (Project MVP) "Project Day Numbering" article here at http://www.mpug.com/News/Pages/ProjectDateNumbering.aspx
2012년 5월 8일 화요일 오전 2:02
Thanks Brian!! Your solution worked. Very neat & tidy. Date format adjusted & no worries. Excellent work thanks for your response.
2012년 5월 8일 화요일 오전 2:03중재자
2012년 5월 8일 화요일 오전 2:07
Thank you for the link. A good read. I will use this for future template developments. :)