Skip to main content

Notifications

Microsoft Dynamics AX forum
Answered

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

Posted on by 40
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 40 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 225,254 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

Community Spotlight of the Month

Kudos to Mohamed Amine Mahmoudi!

Blog subscriptions now enabled!

Follow your favorite blogs

TechTalk: How Dataverse and Microsoft Fabric powers ...

Explore the latest advancements in data export and integration within ...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 284,737 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,254 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,146

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans