Asset Compare dates in 2 attributes

[Michael Frade]

Trying to sync up 2 date attributes in different Object types.  Want to find the ones that do not match.  Object type A has Refresh date attribute and Object type B has End date attribute. Object type A references Object type B thru an attribute in A called Model.  Tried doing "Model"."End Date" != "Refresh Date" and it is not working. Still getting object that have matching dates. 

Any tips?

[Trudy Claspill]

Hello @Michael Frade 

Where are you trying to use that comparison? An automation rule? A search?

[Michael Frade]

It would be in a Branch AQL component in automation but testing the AQL query in the filter in Assets itself as I was not getting the desired results. It's the same in both places,  I am getting results where the dates do match.

[Trudy Claspill]

At the moment I'm stumped, but I'm going to keep working on it...

I get the same results as you.

[Bill Sheboy]

Hi @Michael Frade and @Trudy Claspill 

I do not believe that is possible with the built-in features of AQL: as with JQL, the left-side of an expression must be a field / attribute and not the value of one.

What do you want to do when a match to the condition is found?  Knowing that may suggest alternatives.

Kind regards,
Bill