define first day of last week 1

[CFBaber]

I need to define the first business day of last week and be able to sum month to date values for the month that the first day of last week falls in. The business only does business on days it is open so the first business day of a holiday week may be on a Tuesday.

Thanks for any help!

 

[synapsevampire]

This should help:

http://www.kenhamady.com/form01.html

And this should get you last Monday:

currentdate-(DayOfWeek(CurrentDate)-5)

And this gets you the start of the month:

date(year(currentdate), month(currentdate),1)

Hardcode the holidays and adjust as required, or you might use the crystal supplied bussinessdays UFL to help in this (available for download).

Some work to be done yet...

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[dgillz]

Try this:

Minimum(LastFullWeek)

This will return a Sunday. If you want to start with Monday just add 1 to it. Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[CFBaber]

Thanks to both of you! I can make this work

 

[synapsevampire]

Purdy slick, dgillz... I didn't realize that you could use a minimum there.

I always write my own day/week functions these days because I've been burned in the past with either bad functions, or faulty historical instance viewing in CE, I guess it's time to show some faith again...

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com