Hello Again!
Im working on another report, an Aging AR report. And Im trying to make a column were it looks at the MailDate and then determines the Age of the AR -
Case WHEN [Open AR 1].MailDate > GetDate()-30 THEN 'Current'
WHEN [Open AR 1].MailDate BETWEEN GetDate()-31 AND GetDate()-61 THEN '31-45 Days'
WHEN [Open AR 1].MailDate BETWEEN GetDate()-61 AND GetDate()-90 THEN '61-90 Days'
WHEN [Open AR 1].MailDate <= GetDate()-91 THEN 'Over 90 Days'
ELSE 'error' END As Age
Basically what its currently doing in the Column is putting 'Current' when the jobs are less than 30 days which is what I want. And also putting 'Over 90 Days' for Jobs were the maildate is past 90 days. Everything else however it gives the 'error' in the column.
Im working on another report, an Aging AR report. And Im trying to make a column were it looks at the MailDate and then determines the Age of the AR -
Case WHEN [Open AR 1].MailDate > GetDate()-30 THEN 'Current'
WHEN [Open AR 1].MailDate BETWEEN GetDate()-31 AND GetDate()-61 THEN '31-45 Days'
WHEN [Open AR 1].MailDate BETWEEN GetDate()-61 AND GetDate()-90 THEN '61-90 Days'
WHEN [Open AR 1].MailDate <= GetDate()-91 THEN 'Over 90 Days'
ELSE 'error' END As Age
Basically what its currently doing in the Column is putting 'Current' when the jobs are less than 30 days which is what I want. And also putting 'Over 90 Days' for Jobs were the maildate is past 90 days. Everything else however it gives the 'error' in the column.
