Datetime filter not working

[Deana_Marshall]

What is your goal?

I am trying to filter bundles with either date added or date modified that happened the previous day

What is the problem & what have you tried?

It is passing everything through the filter regardless of the date. I have made sure that it is in date format.

[Deana_Marshall]

Here is what I’m working with (not sure why it did not show up in the first post)

[Moid_shaikh]

Your filter is likely failing because the value is plain text, not a real Date, in Make you need to run it through Tools → Date/Time → Parse/Format date first, then use that output in the filter and the date time condition will work correctly.

[Deana_Marshall]

How is that different from what I did in the second and third screenshots?

[Stoyan_Vatov]

It’s not.

Test with a set multiple variables module first and see what you are getting from the outputs and if they match. Then move them to a filter.

At first look - parseDate() usually requires that you tell it what the current format is. Also, you can hover over a variable and see if its of type date already.

[Deana_Marshall]

Tried that and it’s still not working. I didn’t include all screenshots but I did verify that all variables are in date format.

[Stoyan_Vatov]

Try with Earlier than as well.

[Probotic_Solutions]

Hi @Deana_Marshall,

The issue seems to be caused by the date-time formatting in the filter. The following formulas should work:

For Date Add:

{{formatDate(addDays(now; -1); “YYYY-MM-DD”)}} = {{formatDate(22.date add; “YYYY-MM-DD”)}}

OR

For Date Modify:

{{formatDate(addDays(now; -1); “YYYY-MM-DD”)}} = {{formatDate(22.date modify; “YYYY-MM-DD”)}}

@Deana_Marshall If this helps, feel free to mark the answer as a solution

[amjadiqbal]

Just to add to what has been shared above, since you want to filter bundles where EITHER date added OR date modified happened the previous day, make sure you use the Add OR rule button to combine both conditions.

Your filter should look like this:

Condition 1: formatDate(date_added; YYYY-MM-DD) Equal to formatDate(addDays(now; -1); YYYY-MM-DD)

OR

Condition 2: formatDate(date_modified; YYYY-MM-DD) Equal to formatDate(addDays(now; -1); YYYY-MM-DD)

This way any bundle where either the date added or date modified matches yesterday will pass through the filter. Using AND instead of OR would require both dates to match which is probably not what you want.

[Deana_Marshall]

Will it still work if I want it to be later than? I see you are using “equal to” instead of later than.

Also can you help me understand why we are putting it in text format rather than date format?

[Deana_Marshall]

It does not work with that either