last month 1

[kimchavis]

Can someone help me figure out how to do a date range from 01-01-2005 to the end of the last month.

So If i were pulling the report today, I would want to see 01-01-2005 to 02-28-2005.

Any help would be appreciated.

Thanks,
KIM

 

[kskid]

{table.date} in [date(2005,1,1) to dateserial(year(currentdate),month(currentdate),1-1)]

or

{table.date} in YearToDate to minimum(MonthToDate)

or

{table.date} in YearToDate to maximum(LastFullMonth)

Cheers,
-LW

 

[kskid]

Change from

table.date} in YearToDate to minimum(MonthToDate)

to

table.date} in YearToDate to_ minimum(MonthToDate)


The to_ means to exclude the end date

-LW

 

[lbass]

kskid,

I don't think you meant that--yeartodate would give you dates from January 1 to today's date, so using that as the starting point of a range doesn't make sense. Or am I missing something?

I think it should be:

{table.date} in date(2005,01,01) to maximum(lastfullmonth)

-LB

 

[kskid]

You are right. it should have been

{table.date} in YearToDate and
{table.date) < minimum(MonthToDate)

or

{table.date} in YearToDate and
{table.date) <= maximum(LastFullMonth)

-LW