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....? :)
You should be able to do this with a combination of a case statement and using "between".
Even with case it's not working. i think i this may work with Extract function
Did any used this function
closed
cllsed
What did u use ? what was ur filter query for that ?