Forums
Home Product Q&A Discussion groups Articles Ask a question Search
Learning
Events

Forums

Articles
Create
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Product Q&A
See all
Community resources
Top groups
Explore all groups
Community resources
Learn
Community resources
Events
Community resources

relative date doesn't work for Asset date attribute

YY哥 Yang
YY哥 Yang December 4, 2022

Hi,

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

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

 

image.png

Answer
Watch
Like Ollie Guan likes this
506 views

2 answers

0 votes
Pascal Hamar
Pascal Hamar
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
Get involved
February 17, 2023

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

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

Reply
0 votes
Joseph Chung Yin
Joseph Chung Yin
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Become a leader
December 4, 2022

@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.

View More Comments
Yong
Yong
Contributor
December 4, 2022

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

Like
Joseph Chung Yin
Joseph Chung Yin
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Become a leader
December 4, 2022

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

Best, Joseph

Like
Yong
Yong
Contributor
December 5, 2022

no record returned.

Like
Ollie Guan
Ollie Guan
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Become a leader
December 7, 2022

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

Like
Yong
Yong
Contributor
December 8, 2022

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

Like
Reply

Suggest an answer

Log in or Sign up to answer
Jira Service Desk
Jira Service Management
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events

    See all events
    Community
    Forums
    FAQs Forums guidelines
    Learning
    About learning Resources
    Events
    Copyright © 2025 Atlassian
    Privacy Policy Terms Security
    Welcome illustration

    Welcome to the new Atlassian Community

    Online forums and learning are now in one easy-to-use experience.

    By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.