Timestamp comparison in Smartlist filter

Aishwarya_Venka
Level 2

Timestamp comparison in Smartlist filter

Hello,

We have a use case where multiple webinars happen in the same day every week. For example - 2-3 webinars every Tuesday, Wednesday and Friday.

Is there a way I can compare datetime values in a smart lister filter condition?

i.e. if webinar_signup_date is equal to 2018-11-29T20:00:00-05:00

webinar_signup_date is a datetime field on the lead object.

Thanks,

Aishwarya

2 REPLIES 2
SanfordWhiteman
Level 10 - Community Moderator

Re: Timestamp comparison in Smartlist filter

If you're comparing a Datetime type field to a static Datetime value, there's no need to think about comparing date-like Strings (ISO 8601 representations).

Just do an [is] comparison in the filter.

Mary_Rouzer3
Level 2

Re: Timestamp comparison in Smartlist filter

If I understand correctly, you should be able to use 'webinar_signup_date' as a Smart List filter and compare by date is, is not, between, in past, in past before, in future, in future after, in time frame, after, before, on or after.