
1. Re: Date Calculations Help!!
Tom W May 23, 2016 12:13 PM (in response to anushachowdary.sakhamuri)Hi there,
Thanks for the details. It's difficult to help without a packaged workbook though. Can you please attach a Packaged Workbook version to support your scenario?

2. Re: Date Calculations Help!!
anushachowdary.sakhamuri May 23, 2016 4:12 PM (in response to Tom W)Hi Tom,
Thanks for the reply . Unfortunately I cant publish my workbook.
But I have another question .
IF DATEDIFF('day', DATE([S_Date]), TODAY()) <= 7 THEN "Last 7 Days"
ELSEIF DATEDIFF('day', DATE([S_Date]), TODAY()) <= 30 THEN "30 Days"
END
the 7 days is giving me the right results but 30 days gives me the days minus the seven days.
Not sure how to get the last 30 days.
Thank you

3. Re: Date Calculations Help!!
Tom W May 23, 2016 4:34 PM (in response to anushachowdary.sakhamuri)anushachowdary.sakhamuri wrote:
the 7 days is giving me the right results but 30 days gives me the days minus the seven days.
Not sure how to get the last 30 days.
That doesn't make sense  your calculation isn't returning the result of the datediff so I'm not sure how you're arriving at this conclusion. Without seeing an example though, I have no idea how you're arriving at any conclusion.
You don't need to use your actual data, you can mockup an example in Excel. It's really impossible to help you otherwise as I can replicate your formula working exactly as I'd expect  see attached.

YourExample.twbx 10.0 KB
