Define Date 9 weeks out

[Leesha]

Hi,
I have a query that determines the week ending date using this formula:
Week_ending_date: [admit dt]+7-Weekday([admit dt],1)
The user needs to determine the week ending date 9 weeks in the future, from the original week ending date. What would the formula look like?
Thanks!
Leesha

[HansV]

A week is 7 days, so 9 weeks is 9 * 7 = 63 days

Future_date: [Week_ending_date]+63

or, if you prefer

Future_date: [admit dt]+70-Weekday([admit dt],1)

(7 + 63 = 70)

[Leesha]

Perfection! I so appreciate the rationale description behind the code.
Thanks!
Leesha