Need to view the report from 01/01/05 till end prev month 1

[eo]

Hi

I need to create a report, which will be run on a recurring basis using Enterprise for the period Start of the year untill the last day of the previous month.

So if they ran the report today, it would run for 01/01/2005 until 30/04/2005 (UK Date formats). The Start date is obvious, but what would a last day of the previous month formula look like?

EO
Hertfordshire, England

 

[synapsevampire]

Try:

(
{table.date} >= cdate(year(currentdate),1,1)
and
{table.date} <= maximum(lastfullmonth)
)

There is a flawa in your logic, though, what if it's run on january 15th?

You say the starting date of the current year, to the maximum last full month, which would be 12/31/04...

So I'd adjust your logic to:

(
if month(currentdate) = 1 then
(
{table.date} >= cdate(year(currentdate),1,1)
and
{table.date} <= maximum(lastfullmonth)
)
else
(
{table.date} >= dateserial(year(currentdate)-1,1,1)
and
{table.date} <= maximum(lastfullmonth)
)
)

This would give you everything for last year.

-k

 

[kskid]

k,

Wouldn't the following work?

(
{table.date} >= cdate(year(minimum(LastFullMonth)),1,1)
and
{table.date} <= maximum(lastfullmonth)
)

-lw

 

[synapsevampire]

Yep, looks cleaner too, LW.

-k