LastFullWeek date range 1

[johnstrang]

I have checked this, it goes from Sunday to Saturday.

Our business rules define a week as being from Monday to Sunday, so my question is - is it possible either to modify LastFullWeek to go from Monday to Sunday, or to define an equivalent selection criterion?

Many thanks in anticipation

John

 

[johnstrang]

Sorry, as usual I forgot to include technical details:
CR 8.5 with a direct connectio to an Oracle database.

John

 

[Reebo99]

The following formulas work to get the first and last dates of the last full week with a monday startd date:

First Day of Last Full Week :
CurrentDate - DayofWeek(currentdate,crMonday) - 6

Last Day of Last Full Week :
CurrentDate - DayofWeek(currentdate,crMonday)



Reebo
UK

Please Note - Due to current economic forcast and budget constraints, the light at the end of the tunnel has been switched off. Thank you for your cooperation.

 

[rosemaryl]

Dear Johnstrang,

This one works well:

{Table.Date Field} in minimum(lastfullweek)+1 to maximum(lastfullweek)+1

Just replace Table.Date Field above with yours and pop it into the selection formula.

Regards,

ro



Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.