IIF Statment (Days Aged)

[gpouliot]

Hi,

I'm currently using DateDiff("d",[Tran_Date],Now()). What I'm trying to do now is create a category called "Days Aged Cat"

1-7 Days
7-14 Days
14-30 Days
30+ Days

I know I can use the IIF statement and I was able to to do the first one
IIF([Days]<=7,"1-7Days") but this is as far as I got. I'm not sure how to create the remainder of the string. I always get an error.

Thanks

 

[Joe4]

Just keep nesting your IIF statements.

But you first need to determine some definite end-points. If it is 7 days, where does it fall? In "1-7 days" or "7-14 days"?

Your final statement will look something like:

IIF([Days]<=7,"1-7 Days",IIF([Days]<=14,"8-14 Days",IIF([Days]<=30,"15-30 Days","30+ Days")))