Flow designer look up action based on date does not return the expected result

[mfhaciahmetoglu]

Hey all,

I need to look up on hardware assets records where

- Asset function == primary

- Warranty Expiration == today + 2 months (this is a custom field of Date type).

I set up the flow on Flow Designer:

1. Set the flow variable to 2 months from now:

2. Look up records:

All looks fine.

I have a record that meets the conditions: 

I run a test. The variable is set correctly:

The lookup is run okay:

However, as you can see, the record is not returned.

When I set the filter before or after, it does not work either.

Any one has any idea why?

I tried to write a script to see what happens.

var gdt = new GlideDate();

gdt.addMonthsLocalTime(2);

var gd = new GlideRecord('alm_hardware');

gd.addEncodedQuery('asset_function=primary^u_glide_date_1ONgdt;');

gd.query();

while (gd.next()) {

  gs.addInfoMessage(gd.getValue('asset_tag'));

}

This script returns all records.

So, something seems to be wrong but I don't know why.

Any ideas?

Thanks.

Best,

Firat

[Dr Atul G- LNG]

Hi @mfhaciahmetoglu 

I'm not an expert, but based on what I've learned, let's try to break this condition into two parts. First, try to get Asset function == primary and check if the records are coming or not. If yes, then add another condition. This will help us determine whether the issue is with the condition itself or something else.

[mfhaciahmetoglu]

Hi, thanks!

Asset function works, it is the date that does not work. 

It seems that adding a custom flow variable as a condition to compare does not work in any case (I tried before after as well). Weird.

Best,

Firat

[Dr Atul G- LNG]

Hi @mfhaciahmetoglu 

Might be helpful

https://www.servicenow.com/community/developer-forum/reminder-email-every-3-days-after-due-date-on-t...

https://www.servicenow.com/community/now-platform-forum/how-to-send-a-notification-in-the-flow-desig...

[Ankur Bawiskar]

@mfhaciahmetoglu 

try to give the filter as this

Warranty Expitation = Flow Variable

If my response helped please mark it correct and close the thread so that it benefits future readers.