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
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