Sonny Software

Posted: **Tue Dec 10, 2019 8:44 am**

Hi!

I'm really bad at SQL so I'd love some help with this. I'm simply trying to create a group that will contain all articles older than let's say 25 years from "now". How would I do this?

Posted: **Tue Dec 17, 2019 9:55 am**

It's not possible now because of bug in the database engine that will cause a crash. This is fixed in the next update, though. Once it's out, if your date field contains just a year, this SQL will find references published on or before 1950.

cast(theDate as INT) <= 1950

Jon
Sonny Software

Sonny Software

How to create smart SQL group with older articles?

How to create smart SQL group with older articles?

Re: How to create smart SQL group with older articles?