Hi all! I need help coming up with a formula that will give me the date "x" weeks ago. I've tried it a couple different ways but can't get anything to work - though formulas are really not my strong point.
The approach I've been trying to use is multiplying the number from my custom weeks field by 7 (to get the number of days), then somehow subtracting that from today to get the date x weeks ago. Any help with translating that thought into a functioning formula? Or is there a better way to do this?
3 respuestas
Are you using something like this in your custom Week formula?
https://help.salesforce.com/HTViewHelpDoc?id=formula_examples_dates.htm&language=en_US#week-of-year
