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

[Riina Kivi]

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

[John Funk · Accepted solution]

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 > ).

[Riina Kivi]

Yes, thank you, I tried this one:

project = Projektid AND assignee = currentUser() AND "Esitamise tähtaeg[Time stamp]" >= startofday(7) AND "Esitamise tähtaeg[Time stamp]"<= endofday(7) 

and it seems that it works :)

[John Funk]

Great! Glad it is working for you. 

[Kris Dewachter · Accepted solution]

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