Year on Year Formula

[Steve95]

Hi All

I need to create a formula which will be placed in the select expert. Currently the formula is like:

{Datefield} in DATE (2005,01,01) to maximum(lastfullmonth)

with this formula at the beginning of every year I got to pull down from BOXi 40+ reports change date year and re-upload, time consuming or what......

What I want to be able to do is have a formula which will allow the years to roll as per norm and the second part of the formula still referring to the last fullmonth.

Please can you advise?

Many Thanks in advance

 

[Madawc]

Year(Date) = Year(currentdate)

or maybe

Year(Date) = Year(currentdate)-1

A separate test for your last full month.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[Steve95]

Thanks for the formula, but this formula will not resolve my issue....

Any other ideas?

Many Thanks

 

[lbass]

Try:

if month(currentdate) <> 1 then
{table.date} in minimum(yeartodate) to maximum(lastfullmonth) else
{table.date} in date(year(currentdate)-1, 1,1) to date(year(currentdate)-1,12,31)

-LB

 

[Steve95]

Excellent solution....

Many Thanks lbass