SAS VA 8.3 - Filter and display data that is 6 months or older

[tweehh]

Hi!

I am trying to filter and display the tickets that are 6 months or older since the date those tickets were opened. Any ideas how to do this? Any help would be appreciated! 

[Sam_SAS]

Hello,

I believe this should be possible but a bit annoying to do.

You can perform math on dates by using the TreatAs operator and remembering that the date values are the number of days since 01JAN1960 (in this case, we don't care when day zero was.)

You can use an expression like this to determine the 'age' of a date value:

TreatAs(_Number_, DatePart(Now())) - TreatAs(_Number_, 'Facility Opening Date'n)

Then you could compare this number to 180 to approximate a six month cutoff.

So your advanced filter expression would look something like this:

( TreatAs(_Number_, DatePart(Now())) - TreatAs(_Number_, 'Facility Opening Date'n) ) >= 180

Let us know if that works,

Sam

[tweehh]

Thank you for your response!

I created the first filter (see below) on the report but the results are negative.

TreatAs(_Number_, DatePart(Now())) - TreatAs(_Number_,
'Opened at (Date)'n)

[Sam_SAS]

It's a bit unusual that your data item has parentheses in the name. I'm not sure if that could be an issue, or possibly the Opened At column is a datetime value, in which case wrapping in the DatePart() operator should yield the desired result.

[Sam_SAS · Accepted solution]

The other issue I forgot to mention is that if you make this a calculated item, you need to set an aggregation other than Sum. That is probably why you are getting such large values.