_add_days function based on date prompt

[phani1979]

Hai
Here my logic is If used selects a date from date prompt,  report should display current month and next month and next months  data like

0-30, 31-60, 60-90,90-120, days, how much of amount is different for each month..

I have two fileds, Creation_Date and Amount

Date prompt is filtered by Creation Date

based on Date prompt, i have to show aging periods of 4 months

what i have done is i had created  4 data item using _add_days (c.date,0) (c.date,30) ...60,90,120

if select (c.date,0) it will display prompt selected date, if we go for 30, it will display next 30 days,,...


now i have to filter date prompt  based on user selection date..  from that date i have to display  current month, next month, 2 month, 3 month, 4 months of date,

for that  i have written calculation
if(?Date? >=[zero] and ?Date?<=[thirty]) then ([AMOUNT]) else([AMOUNT]), but it's giving an error..


Suggest me  what to do....? :)

[Moody]

You should be able to do this with a combination of a case statement and using "between".

[phani1979]

Even with case it's not working. i think i this may work with Extract function

Did any  used this function

[phanicrn]

closed

[phanicrn]

cllsed

[Desperado]

What did u use ? what was ur filter query for that ?