Add 10 weeks to a date
I'm a little stuck, I need a calculation that adds 10 weeks to a previously entered date.
ie. SlabDate + 10 weeks = date to start internal work on house.
Hope you can help.
Here is one way:
Create a field called "Internal Start Date" (or whatever) and make it of the Calculated type.
For the Calculation, enter:
SlabDate + 70
... and set the result type as "Date"
I'll try it when I get to work. Thank you so much Lyle!
may u could use :
date ( month (slabDate) ; day (slabDate) + 70 ; year (slabDate) )
... both work equally as well since we are talking about days. The first would be easier to write in this instance and, to FM days are days but understanding the power of the second calculation is important as well because it allows maximum control over the results. Date calcs are cool!
Retrieving data ...