No Date condition in Filter

[son_ds]

Hi everyone!

I am creating a filter that sort out events that are more than 1 week old, and apparently on ZM's documentation, I should look for the Date element in the filter and set the value of -7.

But I do not see any "Date" or "Date/Time" element in the drop down list. All I have is Start Date or End Date, and input -1 or -7 does not give me any result. Is this feature removed and ZM doc has not been updated accordingly?

[banzaay]

I have the same problem, I'm trying to create a rule that delete all the messages older than 10 days.

How can I do that ?

Thanks

[iconnor]

Use Start Date. Events have both a start and an end.

[banzaay]

I have created a filter in this way (sorry for the image in italian):

Schermata del 2019-12-16 12-24-15.png (33.04 KiB) Viewed 2008 times

Start Date <= -10 days

But it is not working.

[iconnor]

Okay use Start Date / Time I know it works, I will go test Start Date.

Please note that Start Date / Time is actually faster, as it results in sql that looks like:

Starting < '2019-12-17 00:00:00'

whereas StartDate results in

date(Starting) < '2019-12-17' which means mysql has to perform a function on each Starting value and can't use indexes.