How can I filter Date with No Value on Nav Query DataItemTableFilter

(0) Share

Report

Posted on by Shu Foster

Hello

I am new to Nav Query

I am trying to creating a query through Nav Development Environment with filtering "Requested Receipt Date" is empty

I have tried "<>0" and " ", but it asks me to put a valid date

What is a valid date I should put in order to filter no date ones?

I have the same question (0)

All responses (11)

Answers (1)

Suggested answer

Nitin Verma 21,688 Moderator on at

Like (0)

Report

RE: How can I filter Date with No Value on Nav Query DataItemTableFilter

Hi,

Please try with ‘<>%1’,0D

Thanks

Was this reply helpful? Yes No
Shu Foster 25 on at

Like (0)

Report

RE: How can I filter Date with No Value on Nav Query DataItemTableFilter

Thank you but no, it does not work, it still shows "Not a valid Date".

Was this reply helpful? Yes No
Nitin Verma 21,688 Moderator on at

Like (0)

Report

RE: How can I filter Date with No Value on Nav Query DataItemTableFilter

Please share your code or filters here

Was this reply helpful? Yes No
Suggested answer

Teddy Herryanto (Th... 14,207 Super User 2025 Season 2 on at

Like (1)

Report

RE: How can I filter Date with No Value on Nav Query DataItemTableFilter

SetFilter("Requested Receipt Date",'<>%1',0D); //not empty date

SetRange("Requested Receipt Date",0D)l; //empty date

Was this reply helpful? Yes No
YUN ZHU 92,886 Super User 2025 Season 2 on at

Like (0)

Report

RE: How can I filter Date with No Value on Nav Query DataItemTableFilter

Hi, just add others' reply.

Blank date is specified bu 0D in NAV.

More details: https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/methods-auto/date/date-data-type

Hope this also helps.

Thanks

ZHU

Was this reply helpful? Yes No
Shu Foster 25 on at

Like (1)

Report

RE: How can I filter Date with No Value on Nav Query DataItemTableFilter

Thank you, I have found the answer. it is >01011900 as SQL stores no date in the table as a date from the 1700’s rather than blank.

Was this reply helpful? Yes No
Shu Foster 25 on at

Like (0)

Report

RE: How can I filter Date with No Value on Nav Query DataItemTableFilter

Thank you, I have found the answer, it is >01011900 -as SQL stores no date in the table as a date from the 1700’s rather than blank.

Was this reply helpful? Yes No
Shu Foster 25 on at

Like (0)

Report

RE: How can I filter Date with No Value on Nav Query DataItemTableFilter

Thank you Teddy, I have found the answer, how can I verify the answer?

Was this reply helpful? Yes No
Suggested answer

Teddy Herryanto (Th... 14,207 Super User 2025 Season 2 on at

Like (0)

Report

RE: How can I filter Date with No Value on Nav Query DataItemTableFilter

Don't remember exactly.

On the replies, there should be a button or action to verify the answers. Only the original requester can see it.

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,688 Moderator on at

Like (0)

Report

RE: How can I filter Date with No Value on Nav Query DataItemTableFilter

Please check this.

Was this reply helpful? Yes No