LastFullWeek (Monday - Sunday) ? 2

[willz99ta]

Hi and thanks for your help,

I am trying to use a Crystal Reports selection query using LastFullWeek as the date range. My problem is that the week at my organization uses Monday - Sunday as the week.

What is the best way to have the date range look for the last full Monday-Sunday time interval?

Thanks for your help,
Will

 

[fisheromacse]

In your record Selection Editor, add:

table.date in [(Minimum(lastfullweek)+1) to (Maximum(lastfullweek)+1)]

 

[lbass]

The formula won't work correctly on certain days though (and I may have made this mistake in other threads myself). For example, if you run a report on Sunday, March 7, the last full week should be 2/22-2/28, since Sunday is not yet complete, but the above formula would return 3/1 - 3/7.

I think a better formula would be:

{table.date} in currentdate-dayofweek(currentdate,crMonday)-6 to
currentdate-dayofweek(currentdate,crMonday)

-LB

 

[bubu2006]

I am also using LastFullWeek. My week is from Monday to Friday. The report will run each Monday morning for last o Monday to Friday. No issue in using the function if I ran the report. Now I want to display the date range which is last Monday and last Friday in the report even if I test the report other than Monday.
Any help will be appreciated.