cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JUANKRZ91
New Member

FILTER DATE FROM EXCEL ERROR

Hi, i'm trying to filter a table from excel using my current date - 1 day, but the resulting table contein values that don't match my filter:

 

@and(equals(item()?['MARCA'], 'HUAWEI'),equals(item()?['ESTADO'], 'PENDIENTE'),greaterOrEquals(item()?['FECHA_GUIA'], convertFromUtc(adddays(utcNow(),-1), 'SA Pacific Standard Time', 'dd/mm/yyyy')))

FLOW 1.png

 

This is the result that contains date greater than 05/11/2019 that is my filter:

 

result.png

 

This is a part of my table:

 

35606/11/2019Juancamilo.ruiz@telefonica.comJcruizza78007653HUAWEITEL GSM HUAWEI MATE 20 LITE LTE AZUL3502 UNIDADES ENTREGADASENTREGADO1,7501,75
35706/11/2019Juancamilo.ruiz@telefonica.comJcruizza41N0387567HUAWEITEL GSM HUAWEI MATE 20 LITE LTE AZUL6003 UNIDADES ENTREGADASPENDIENTE303
35806/11/2019Juancamilo.ruiz@telefonica.comJcruizza41N0387567HUAWEITEL GSM HUAWEI MATE 20 LITE LTE AZUL500 UNIDADES ENTREGADASPENDIENTE0,2500,25
35906/11/2019Juancamilo.ruiz@telefonica.comJcruizza41N0388607HUAWEITEL GSM HUAWEI MATE 20 LITE LTE AZUL8004 UNIDADES ENTREGADASENTREGADO404
36006/11/2019Juancamilo.ruiz@telefonica.comJcruizza41N0388607HUAWEITEL GSM HUAWEI MATE 20 LITE LTE AZUL2001 UNIDADES ENTREGADASENTREGADO101
36106/11/2019Juancamilo.ruiz@telefonica.comJcruizza41N0390683HUAWEITEL GSM HUAWEI MATE 20 LITE LTE AZUL3502 UNIDADES ENTREGADASENTREGADO1,7501,75
36206/11/2019Juancamilo.ruiz@telefonica.comJcruizza80452500HUAWEITEL GSM HUAWEI MATE 20 LITE LTE AZUL5003 UNIDADES ENTREGADASPENDIENTE2,502,5
36306/11/2019Juancamilo.ruiz@telefonica.comJcruizza80452500HUAWEITEL GSM HUAWEI MATE 20 LITE LTE AZUL5002 UNIDADES ENTREGADASPENDIENTE2,502,5
36406/11/2019Juancamilo.ruiz@telefonica.comJcruizzaSZX224781HUAWEITEL GSM HUAWEI MATE 20 LITE LTE AZUL10003 UNIDADES ENTREGADASENTREGADO505
36506/11/2019Juancamilo.ruiz@telefonica.comJcruizza80464380HUAWEITEL GSM HUAWEI MATE 20 LITE LTE AZUL9991 UNIDADES ENTREGADASPENDIENTE504,995
36606/11/2019Juancamilo.ruiz@telefonica.comJcruizza80466122HUAWEITEL GSM HUAWEI MATE 20 LITE LTE AZUL10000 UNIDADES ENTREGADASPENDIENTE505
36706/11/2019Juancamilo.ruiz@telefonica.comJcruizza80466124HUAWEITEL GSM HUAWEI MATE 20 LITE LTE AZUL10000 UNIDADES ENTREGADASPENDIENTE505
36806/11/2019Juancamilo.ruiz@telefonica.comJcruizza80466161HUAWEITEL GSM HUAWEI MATE 20 LITE LTE AZUL10000 UNIDADES ENTREGADASPENDIENTE505
36914/08/2019Juancamilo.ruiz@telefonica.comJcruizza80466162HUAWEITEL GSM HUAWEI MATE 20 LITE LTE AZUL10000 UNIDADES ENTREGADASPENDIENTE505
37015/01/2019Juancamilo.ruiz@telefonica.comJcruizza77996753HUAWEITEL GSM HUAWEI MATE 20 PRO LTE VERDE550 UNIDADES ENTREGADASPENDIENTE0,2800,275
37115/01/2019Juancamilo.ruiz@telefonica.comJcruizza77996753HUAWEITEL GSM HUAWEI MATE 20 PRO LTE VERDE950 UNIDADES ENTREGADASPENDIENTE0,4800,475
37225/01/2019Juancamilo.ruiz@telefonica.comJcruizza41N0382147HUAWEITEL GSM HUAWEI MATE 20 PRO LTE VERDE490 UNIDADES ENTREGADASPENDIENTE0,2500,245
37305/02/2019Juancamilo.ruiz@telefonica.comJcruizza41N0382425HUAWEITEL GSM HUAWEI MATE 20 PRO LTE VERDE450 UNIDADES ENTREGADASPENDIENTE0,2300,225
3 REPLIES 3
edgonzales
Super User II
Super User II

@JUANKRZ91 

This might not be the issue, but is it possible that the dates are stored in UTC and your criteria date is not?  If your filter is only getting "extra" stuff that is a day off, then that's probably the issue...but if you're getting results that are wildly off, it might be something else.

 

If that is the issue, try converting your filter date to UTC using the "Convert Timezone" action and see if that cleans things up.  You can also use an expression if you're comfortable with that.

 

Please keep us posted.

-Ed-

 

If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

hi, I already con vert the filter to the format 'dd/mm/yyyy' the same that the source file but the error continues 

 

@and(equals(item()?['MARCA'], 'HUAWEI'),equals(item()?['ESTADO'], 'PENDIENTE'),greaterOrEquals(item()?['FECHA_GUIA'], convertFromUtc(adddays(utcNow(),-1), 'SA Pacific Standard Time', 'dd/MM/yyyy')))

Are the extra results within a day still? or are they way outside of the range?

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Users online (44,156)