Last Full Month in Last Year

[DudleyBoy]

Hi,

I was wondering if someone could help.

I need to have a formula that gives results for the last full month, but for last year. So if i were to run the report today 18th May 2010 it would return results for All April 2009.

Thanks All

 

[lbass]

datevar x := dateadd("yyyy",-1, currentdate});
{table.date} in dateadd("m",-1,x-day(x)+1) to x-day(x)

-LB

 

[DudleyBoy]

Hi,

I know I'm missing something basic with this:

datevar x := dateadd("yyyy",-1, currentdate});{table.date} in dateadd("m",-1,x-day(x)+1) to x-day(x)

but I keep gettin gthe error that the ")" is missing, where's it missing from?

Any Ideas?

 

[fisheromacse]

the } after current date appears extraneous.

 

[lbass]

Sorry--remove the accidental curly bracket after currentdate:

datevar x := dateadd("yyyy",-1, currentdate);
{table.date} in dateadd("m",-1,x-day(x)+1) to x-day(x)

You do have to substitute your actual date field for {table.date} of course.

-LB

 

[DudleyBoy]

Thanks.

I've removed the }, the date field is also substituted, it's now refering to this part and saying a date is needed

dateadd("yyyy",-1, currentdate);

Any thoughts?

 

[IanWaterman]

Error must be somewhere else as that syntax is correct.

Ian

 

[lbass]

Sometimes the dateadd function will require enclosing in date():

datevar x := date(dateadd("yyyy",-1, currentdate));
{table.date} in date(dateadd("m",-1,x-day(x)+1)) to x-day(x)

-LB