Date field condition in Flow Designer

Ben42
Tera Contributor

Hello Everyone,

 

In the flow designer look up records action.. I want to set condition for date type field. The field is called 'Valid to' and I want to check if 'Valid to' field is 90 days from today. That means if today is March 26th, I need to get records that has 'Valid to' field as June 26th only (90 days from today). 

 

How should the condition look like? I am using as below but it gets me records that are even after June 26th.

 

Ben42_0-1711462994093.png

 

Thanks,

Ben.

 

 

5 REPLIES 5

Dr Atul G- LNG
Tera Patron
Tera Patron

Try 

AGLearnNGrow_0-1711463504812.png

 

 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Hi @Dr Atul G- LNG ,

 

That's what I have tried but it shows all the records that has "Valid to" even after 90 days.. that means it showing all records that has valid to value as june 27, june 28 etc.. too.

 

Thanks,

Ben.

Hi @Ben42 

 

I tried with UI policy and getting expected error:

AGLearnNGrow_0-1711468517346.png

 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

I am trying this in Flow. and giving below values. Can you share the ui policy you tried?

 

Ben42_0-1711470332442.png

 

Thanks,

Ben.