Microsoft Dynamics AX (Archived)

Under review by Community Managers

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

Posted on by CU15051611-0

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?

Categories:

Helpful resources

André Arnaud de Cal... 290,900 Super User 2024 Season 2

Martin Dráb 229,275 Most Valuable Professional

nmaenpaa 101,156

Leaderboard