relative date doesn't work for Asset date attribute

[YY哥 Yang]

Hi,

The below AQL returns empty, which is out of my expectation. Anyone knows the reason?

objectType = "SaaS 软件" AND "Next Charge Date" < 2w

[Pascal Hamar]

I don't know exactly but maybe this AQL works for your case:

objectType = "SaaS 软件" AND "Next Charge Date" < now(-2w) 

[Joseph Chung Yin]

@YY哥 Yang -

Welcome to the community.  Are you trying to obtain object data which are 2 week ago?  If so, please try "-2w".

Best, Joseph Chung Yin

Jira/JSM Functional Lead, Global Infrastructure Applications Team

Viasat Inc.

[Yong]

I query which objects will be due/expired in 2 weeks.

[Joseph Chung Yin]

Did -2w in AQL returned any record for you?

Best, Joseph

[Yong]

no record returned.

[Ollie Guan]

 "Next Charge Date" is a custom field from JSM?

[Yong]

No,  "Next Charge Date" is an Asset CMDB attribute, but not jira custom fields.