LastFullWeek 1

[Wabush]

I am running a report using the 'lastfullweek' function in the Select expert and want to display the dates included in a Title or header. ie. From {firstdayofweek} to {LastDayofWeek}.

Thanks,

Deanna

 

[dgillz]

Try a formula like this:

"Includes orders from "+totext(minimum(LastFullWeek))+" to "+totext(maximum(LastFullWeek)) Software Support for Sage Mas90, Macola, Crystal Reports and Goldmine

 

[kenhamady]

That is cool. It never occured to me to use Min and Max with those array functions. Pretty handy. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[dgillz]

Also usage on a range paramter like Daterange, CustomerRange, ItemRange, etc. Software Support for Sage Mas90, Macola, Crystal Reports and Goldmine

 

[kenhamady]

That is what is funny. I use Min and Max all the time with range parameter fields. It never occured to me that the date functions have actual array values that you can capture. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[Wabush]

That works like a charm.

Thanks!

Deanna