How to set e-mail notification for Date Time Picker type field

Question

Hi,
I'm trying to create a filter subscription for reminding due date (custom field, field type=Date Time Picker), but it doesn't work.
I have a similar filter subscription with a another custom field and it works perfectly, only difference is in field date, this one is Date Picker.
I use following filter:
project = Projektid AND assignee = currentUser() AND "Esitamise tähtaeg[Time stamp]" = 7d (this one doesn't work)
project = Projektid AND assignee = currentUser() AND "Projekti tähtaeg[Date]" = 14d
(this one works correctly)

Permissions and subscription details are identical.
Could some suggest what's the problem?
Does it really depend on field type or there is something else?

thanking in advance

Kris Dewachter · Accepted Answer

Hi @Riina Kivi ,

I can see the 2 dates don't have the same format. One is a "Time Stamp" and the other is a "Date".

Can you check if this works :

project = Projektid AND assignee = currentUser() AND "Esitamise tähtaeg[Time stamp]" < startOfDay("-7d")

Best regards,

Kris

John Funk · Accepted Answer

Hi Riina, You can't use = with the Time stamp one because it would try to make the value equal to an exact time as well as the date, which it cannot do. You will need to use something like >= or <= (or maybe even just < or > ).