Filter Array condition giving random dates

(0) Share

Report

Posted on by Scribbler

Hello,

I am trying to return dates from a .csv where the records "Completion Date" is within the last 7 days.

In basic mode:

In advanced mode to show code:

I am receiving records with dates reaching back all the way to earliest is March 1st, 2022 and the most recent being May 15th, 2024.

Is there a better expression or condition I can be using here to receive only dates within the last 7 days?

The format I am using is dd-MM-yyyy.

I didn't think it was required to mention, but ff any more information is needed to advise, I can provide further details of all the previous operations that lead to this filter array.

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

VictorIvanidze 13,073 on at

Like (0)

Report

Format both dates to yyyyMMdd.

Was this reply helpful? Yes No
Scribbler 20 on at

Like (0)

Report
The .csv file contains the date in this exact format:

01-Mar-2022 12:19 PM America/New York

Here is a quick overview of the flow:

In the Apply to Each, there is a CreateJSON where I change the date format to 'dd-MM-yyyy':
formatDateTime(first(split(outputs('DefineRecordItems')?[18], 'America/New York')), 'dd-MM-yyyy')

Here I removed the 'America/NewYork' with split and specify the date format to 'dd-MM-yyyy'

I had tried your suggestion before replying back, and changed the format in both this step here, as well as the addDays expression within the filter array below to yyyyMMdd, but received no outputs in the filter array:

Format showing in CreateJSON:

No outputs:

Hope I am not too spotty in my explanation of the workflow, thought to mention only the operations I am handling the dates.

Was this reply helpful? Yes No
VictorIvanidze 13,073 on at

Like (0)

Report

Did you change the expression in the Filter array action?

Was this reply helpful? Yes No
Scribbler 20 on at

Like (0)

Report

Yes, to the format you suggested, yyyyMMdd. First test I changed it in the Filter Array and in the CreateJSON for Completion Date where I showed the code snippet above with the formatDateTime. I received no outputs as I showed in the previous post.

I just tested again. This time I changed my date format in the CreateJSON for the Completion Date back to the format I had before, and changed only the Filter array to your suggested date format.

I'm still seeing dates from 2022, and not within 7 days ago.

Was this reply helpful? Yes No
Verified answer

Scribbler 20 on at

Like (0)

Report
I was able to successfully filter the dates to receive all items for Completion Date within the last 7 days with your suggested date format. I used the format "yyyy-MM-dd" in the Filter Array as well as in the CreateJSON operation:

CreateJSON:
formatDateTime(first(split(outputs('DefineRecordItems')?[18], 'America/New York')), 'yyyy-MM-dd')

Filter Array:
addDays(utcNow(), -7, 'yyyy-MM-dd')

Thank you for your help!

Was this reply helpful? Yes No