Date values for last week
Hello All,
Our users want to display some default date values in custom reports. If they run the report on monday morning then they should get the default data from last week (Monday to Sunday) and it will be effective for the current weekdays between (Monday to Sunday)
that means if they run the report on tuesday or wednesday still they should be able to get the data from last week (Monday to Sunday). These are the weekly reports.
May 9th, 2011 9:50pm
Hi Jimmy,
You can try this in your default date parameter value expressions
Set First Day of previous week (Monday)
=DateAdd(DateInterval.Day, -6,DateAdd(DateInterval.Day, 1-Weekday(today),Today))
Set Last Day of previous week (Sunday)
=DateAdd(DateInterval.Day, -0,DateAdd(DateInterval.Day, 1-Weekday(today),Today))
Thanks
Hardik
Free Windows Admin Tool Kit Click here and download it now
May 9th, 2011 9:58pm
Thank you so much Hardik!!!
I have been looking for a few hours on how to do this!!! Very helpful!!!!
September 26th, 2011 5:13pm