bec9196
June 16th, 2009, 01:20 PM
Hey all. I am trying to create a if, then, else formula. If there is another way to do this then I could use the help.
I need to show aged requests from a global start date of 10/01/2008 through today's date for certain sections, milestones, and offense types. I have created Parameter fields and formula fields for the milestones, sections, and offense types. They are in the report and work great. Now I have to figure out how to get the data from the system.
0 - 30 days, 31 - 60 days, 61 - 90 days, etc.
I can not put all of the data in the same field because my supervisor wants it shown separately so there needs to be a formula for each date range.
This is what I have so far and it returns "A date-time range is required here" when I click on the "Use Expert Wizard".
f {requests.req_stat} = "AdminReviewed" then
({requests.rpt_date} - 30) to CurrentDate else 0
I need to show aged requests from a global start date of 10/01/2008 through today's date for certain sections, milestones, and offense types. I have created Parameter fields and formula fields for the milestones, sections, and offense types. They are in the report and work great. Now I have to figure out how to get the data from the system.
0 - 30 days, 31 - 60 days, 61 - 90 days, etc.
I can not put all of the data in the same field because my supervisor wants it shown separately so there needs to be a formula for each date range.
This is what I have so far and it returns "A date-time range is required here" when I click on the "Use Expert Wizard".
f {requests.req_stat} = "AdminReviewed" then
({requests.rpt_date} - 30) to CurrentDate else 0