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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics