Skip to main content

Notifications

Microsoft Dynamics AX forum
Answered

Adding !=dateNull() range in an AOT query range date field

Posted on by 31
Hello,
I need to add a query range for a date field in an AOT query.
I need to ignore date field values that are empty (should be != dateNull()).
I have tried adding !=dateNull() in the AOT query range but it is not working.
I have tried scripting the view structure in SQL and it is showing the range for the date as followed:
Can anyone please help me on how to do it?
  • CU15051611-0 Profile Picture
    CU15051611-0 31 on at
    Adding !=dateNull() range in an AOT query range date field
    Hello Martin,
     
    Yes, I thought that given the field type was a date, it would require a different type of range but the !"" works perfectly fine.
    Thanks.
  • Verified answer
    Martin Dráb Profile Picture
    Martin Dráb 224,463 Super User on at
    Adding !=dateNull() range in an AOT query range date field
    dateNull() can't be used there. I don't remember - wouldn't simple !"" work?

Helpful resources

Quick Links

Can you answer this forum question?

You could make someone's day!

Community Newsletter - May 2024

Kudos to our community stars!

Community Spotlight of the Month

Kudos to Mohamed Amine Mahmoudi!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 283,623 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 224,463 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,146

Featured topics

Product updates

Dynamics 365 release plans