Crystal Report Formula

[DudleyBoy]

Hi,

Could someone help me with modifying this formula.

if {message_stats.msg_transmission_date} >= DATEADD ("m", -12, CURRENTDATE-day(currentdate))+1 and
{message_stats.msg_transmission_date} < maximum(lastfullmonth) + 1 then {message_stats.msg_premium}

This returns a value if the date is within the last 12months to the the end of last full month.

I just need a variant of this that would do it for the year before, e.g. if i ran it today, October 2010, then it would return value with the date range of October 1st 2008 to end September 2009.

Thanks it advance to all for your help.

 

[Madawc]

Try writing a formula that uses DateDiff, and find the difference in months. I think you're wanting records between 13 and 24 months, but try it and check. Be sure what the results are before using them to select.

DateDiff will also show the difference in years, that might be what you want.

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP

 

[lbass]

if {message_stats.msg_transmission_date} >=
DATEADD ("m", -24, CURRENTDATE-day(currentdate))+1 and
{message_stats.msg_transmission_date} <
DATEADD ("m", -12, CURRENTDATE-day(currentdate)+1)-1
then {message_stats.msg_premium}

-LB