Measure for open requests older than X

[dwalby]

Hi all,

I'm trying to create a measure that shows the number of open requests older than 1 month old for example.

I'm no SQL expert but came across a post online that suggested that adding h_datelogged <= GETDATE() - 31 to the WHERE query would work, unfortunately not though.

Any help appreciated

[Victor]

@dwalby try this in the WHERE clause:

h_datelogged >= NOW() - INTERVAL 1 MONTH

 

*don't forget to have the h_status criterion in there as well...

[dwalby]

Thanks @Victor I have a figure showing now, hopefully that's it. I'll keep an eye on it.