I have a theory that Marketo's "in future before xx days" uses hours as a unit of measurement. Can anyone confirm or provide insight? Situation: We want to send a renewal notice to customers whose subscriptions expire 30 days from the send date. We are using expiration date "is in future 31 days", and expiration date "is in future after 30 days" to isolate that 30th day before expiration. We are transitioning these renewal notices from an old marketo instance to a new marketo instance. I'm noticing some weird discrepancies between the two systems and I want to know more about how Marketo calculates those natural language durations for "in future 31 days" and "in future after 30 days". Example:In the old system Contact A's expiration date is set as 4/5/2024 (no timestamp)In the new system Contact A's expiration date is set as 4/5/24 11:59pmIn the old system, Contact A qualifies for the smart list and is sent the renewal notice on 3/5/24. However, in the new system Contact A qualifies for the smartlist and is sent the renewal notice on 3/6/24. Why is that if they both show the same day date and both are using identical smart list filters. (Assume everything else about the data and smartlist are identical) Side note:The old system's timezone is PSTThe new system's timezone is EST So my question is, does Marketo calculate the natural language filters for "in future" and "in future after" in hour increments and the timestamp is causing the same contact to qualify on different dates? UPDATE: I suspect Marketo is processing in hours because 722 hours before 4/5/24 00:00 is 3/5/24, whereas 722 hours before 4/5/24 23:59 is 3/6/24. (30 days is 720 hours, so I'm looking for justafter 720 hours)

Hi@KatieZ-I wanted to clarify how filters work in Marketo when it comes to applying them based on days. In Marketo, 1 day is considered as 24 hours. If we have data available with both date and time, we can filter it more accurately based on time. However, if we only have the date, Marketo will count every date as 1 day.In relation to your filters in hours, it is important to consider the recurring batch campaign scheduling time. For example, let's say Contact A has an expiration date of 3/31/24 10:59PM EST and you want to send an email on March 1st, 2024 at 09:00 AM EST. In this case, the filters should be set as "in future after 711 hours" and "in future 735 hours."The logic behind this is that there are 30 days in a month, equaling 720 hours. Since you are sending the email at 9 AM EST, subtracting 9 from 720 gives us 711 hours. Similarly, with 31 days in a month, you get 744 hours, so subtracting 9 gives us 735 hours.I hope this explanation clarifies any questions you may have had.If this solution meets your requirements, please mark it as the solution.