Last Sunday of the month 1

[egomouse]

Using Crystal Reports V8.5

I need a formula that will work out the last sunday of the month when a report is run. So if a person runs this report today the formula will produce a date of 26/06/05.

But i also need it in a format that i can use in the select statment.

 

[kenhamady]

This formula should work:

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

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guides for Formulas, Parameters, Subreports, VB, .NET, Tips and Tricks

http://www.kenhamady.com/