Subtract Weeks from a date

[wanzek1]

I want to be able to run a report without having to enter a beginning date. I would like to enter the ending date and create a formula for ending date minus 6 weeks.

Is this possible?

 

[SkipVought]

hi,

A week is 7 days and all date values are in days.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[wanzek1]

How do you account for months with 30 days and months with 31 then?

 

[SkipVought]

A week is a week regardless of months with 28, 29, 30 or 31 days.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[SkipVought]

Could you post some examples and explanation of your concerns regarding month?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[pmax9999]

The following formula would give you a date 6 weeks (42 days) prior to the end date parameter:

{?End_Date}-42

Is that what you are looking for?

Pete

 

[wanzek1]

I actually always need the Saturday of the week but I think I got it to work by just decreasing the # of days I am subtracting.

Thanks!

 

[pmax9999]

Your solution will only work if the report is only ever run on the same day each week. If the report can be run on any day of the week, the formula would need to be dynamic.

This also demonstrates the problem with not fully describing the issue you are trying to resolve.

Pete

 

[SkipVought]

INT(({somedate})/7)*7

This will return the Sat for and date in the week

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}