Filter array for date greater than today

(0) Share

Report

Posted on by Cgangweg01

727 Super User 2025 Season 2

Hello -

Trying to filter an array for records with Promotion Start Date greater than today.

I figured a basic query would work but it does not. It likely requires date formatting and a UTC expression, but I cannot get the syntax correct for an advanced query either.

Any suggestions?

Example input to the filter:

Basic filter that does not work:

My failed attempt to write advanced query:

@equals({formatDateTime(item()?['Promotion Start Date'],'yyyy-MM-dd')},{formatDateTime(addDays(utcNow()+1,'yyyy-MM-dd'))})

Any guidance would be greatly appreciated!

Thanks, Chris

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

SpongYe 5,609 Super User 2025 Season 2 on at

Like (0)

Report
Hi,

Your advanced query would look like:
@equals( formatDateTime(item()?['Promotion Start Date'], 'yyyy-MM-dd'), formatDateTime(addDays(utcNow(), 1), 'yyyy-MM-dd') )

Hope this helps!

Was this reply helpful? Yes No
Suggested answer

KT-11121621-0 14 on at

Like (0)

Report

Hi,

1. Your filter query should use the object that you select using the Dynamic content builder. You select it from the list in the pop-up.

2. The expression on the right-hand side should be: formatDateTime(utcNow()). You'll need to use the Dynamic content builder to type the expression

Here's what the advanced filter should look like:

@greater([your_date_field], formatDateTime(utcNow()))

** what if the Promotion date is today? you can use greater than or equal as well.

Good luck and let us know how it goes.

Was this reply helpful? Yes No
Cgangweg01 727 Super User 2025 Season 2 on at

Like (0)

Report

Hello @SpongYe

Thank you so much! That worked but I did have to change it to @ greater than.

I don't have this syntax down yet ... I want to make that advanced query a combined one with 'And' ...

@equals(item()?['Price Type'],'STORE')

Any suggestion for that?

Thanks Again!

Was this reply helpful? Yes No
Verified answer

SpongYe 5,609 Super User 2025 Season 2 on at

Like (1)

Report
Hi @Cgangweg01

Then the code would look like:

@And( greater( formatDateTime(item()?['Promotion Start Date'], 'yyyy-MM-dd'), formatDateTime(addDays(utcNow(), 1), 'yyyy-MM-dd') ), equals( item()?['Price Type'], 'STORE' ) )

Was this reply helpful? Yes No
Cgangweg01 727 Super User 2025 Season 2 on at

Like (0)

Report

Thank you!

Was this reply helpful? Yes No