Doesn't bring back the expected results...

is there another way to write this?

Many Thanks !!!!

Cool the minus 1 worked...but now my problem is that I already have this expression to format the date:

=Format(CDate(Fields!Next_Payment_Due_Date.Value),"yyyyMMdd")

How can I use both of these together? Is it possible?

=DateAdd(DateInterval.Month, -1,...

This works, but it adds a month, I was looking to subtract a month.

Thanks everyone, very informative and helpful.

Good karma to you all!

Thanks guys, I ended up using this on every DB - (in case someone else needs it)

SELECT routine_name, routine_type FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_DEFINITION LIKE '%cam%'

go

SELECT routine_name, routine_type FROM INFORMATION_SCHEMA.ROUTINES WHERE...

Thanks!

Guess it's different because I'm using BIDS 2008

I'm using the BI..

Looks like that screen shot is from report manager?

oh okay my mistake sorry

excuse my ignornace, so I shouldn't use a declare statement?

what should I use for the @date parameter?

I'm confused now.

I don't wat a start date between and an end date.

I just want the user to pick one date from the calender and have it use that value...

Thanks Guys

True..

I was asking because last place I worked had it disabled, new place doesn't.

Wasn't sure if it created a vunerability.

Thanks Guys!

Thanks!!