Date range selection criteria formula for specified period 1

[urbanhim]

I need to run a report for a date range that I cant for the life of me work out how to do it...

I have a Date field:

{AUDIT_ACCOUNT_EXCHANGE_ACCESS.CREATED_DATE} which needs to show data from (and including) the THIRD friday of the previous month, to the THIRD thursday of the current month.

I cant workout how to do this, any help would be appreciated.

Thank you




UrbanHim
Crystal XI Report Writer
London

[small]What's the best cure for a hangover?... Heavy drinking the night before!![/small]

 

[raja2008]

Hello !

may be this will help you a little.

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

 

[CR85user]

Try the following:

{AUDIT_ACCOUNT_EXCHANGE_ACCESS.CREATED_DATE} in
(if dayofweek(minimum(lastfullmonth)) = 7 then
minimum(lastfullmonth) + (27 - dayofweek(minimum(lastfullmonth))) else
minimum(lastfullmonth) + (20 - dayofweek(minimum(lastfullmonth))))
to
(if dayofweek(minimum(monthtodate)) in [6,7] then
minimum(monthtodate) + (26 - dayofweek(minimum(monthtodate))) else
minimum(monthtodate) + (19 - dayofweek(minimum(monthtodate))))

 

[urbanhim]

This formula is spectacular!! It works a treat, thank you so much! Its brilliant!!

UrbanHim
Crystal XI Report Writer
London

[small]What's good for a hangover?... Heavy drinking the night before!![/small]