Find last saturday in a month 1

[CrystalizeCanada]

Hi there,

I'm trying to determine fiscal periods. The fiscal periods end on the last sat of the month. The following period would then start on the following day (so they can cross over months).

My first step is to determine (I think) which day of the month is the last Saturday - is this a good approach?.

I'm thinking of looping backwards and checking the last day of the month and checking to see if its a saturday.

Any help guidance would be great.

Tx



Gordon BOCP
Crystalize

 

[lbass]

Try Ken Hamady's solution:

http://www.kenhamady.com/form19.shtml

-LB

 

[CrystalizeCanada]

Great - thats what I'm after

Thanks

Gordon BOCP
Crystalize