We have a custom user attribute "sub_expires" of the type "Date". We would like to target all users whose sub_expires falls within the next 24 hours to send a reminder. However, none of the date filters seem to do what we want.
Translating our need to a relative date would be "(sub_expires in) less than 1 day", but the relative filter is "days ago". So we target "less than -1 days ago", but this segment is returning everyone with the property.
If we target "exactly 0 days ago", it returns everyone who expired today.
If we target "exactly -1 days ago", it still returns everyone who expired today (we would expect this to return zero as the negative is "exactly tomorrow").
If we target "less than -1 days ago" we get people expiring in 2025.
Are negative filters not allowed? Is there an issue with our data type? Am I interpreting these filters incorrectly? Any help would be greatly appreciated!