Filter showing unwanted results

[iamkurt]

PFA screenshot - I want results from 2 days in 2023 but the system is returning results from 2024. What am I doing wrong?

Any suggestion would be appreciated
Thanks

[SK Chand Basha · Accepted solution]

Hi @iamkurt It seems you are using wrong query i checked in PDI it's work fine

I'm attaching screenshot for your information

Mark it Helpful and Accept Solution!! If this helps you to solve.

[Dr Atul G- LNG]

HI @iamkurt 

I tried to find out, but I did not get anything.

I think when we run query it goes in logs somewhere and bring results but the field show the latest update dates, which is expected I think.

[Abhay Kumar1]

@iamkurt You are using or condition that will match both either of conditions and give results.

Use And in place of or and you can have your required output.

hope this will help you 

[SK Chand Basha · Accepted solution]

Hi @iamkurt It seems you are using wrong query i checked in PDI it's work fine

I'm attaching screenshot for your information

Mark it Helpful and Accept Solution!! If this helps you to solve.

[Satishkumar B · Accepted solution]

Hi @iamkurt 
You are using wrong filter condition. can you use the between condition. refer below image:

…………………………………………........................................................................................
Mark it helpful 👍and Accept Solution ✅!! If this helps you to understand.

…………………………………………........................................................................................