Using Varchar Converted Date to have a last month Filteration

[gosoccer]

Hi everyone, :) :)

I'm trying to use the following to get the last month but since it's a DMR Model and I have to have
the date into Character.

[Order date] between _first_of_month(_add_months(current_date,(((intdiv(extract(month,current_date)-1,3) * 3) + 1)-extract(month,current_date)))) and current_date

The problem is I had to change the [Order date] to character in order to Deploy the package and not to get the following error (DMR).

So, now that the date is in varchar, cast([Order date],varchar(12)), how can I can use this date in Report Studio Query
to get the last month using the above Filtration?

Thx so much, 8) 8)

[bus_pass_man]

Hopefully the answer in http://www.cognoise.com/index.php/topic,31064.0.html will solve this problem.  Have separate attributes for your key and member captions.