Timestamp comparison in Smartlist filter | Community
Skip to main content
Aishwarya_Venka
Aishwarya_Venka
Level 2
November 26, 2018
Question

Timestamp comparison in Smartlist filter

  • November 26, 2018
  • 2 replies
  • 2291 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

SanfordWhiteman
SanfordWhiteman
Level 10
November 27, 2018

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
Mary_Rouzer3
Level 2
November 27, 2018

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.

Terms & ConditionsAccessibility statement

Loading footer...