Date on query

[moi]

Hello all,

How to filter (date field) blank/no value of a query.. "IsNotNull" is not working..

I wanted to show only records with value (date).

Thank you.

 

[bob fitz]

Try

Is Not Null

 

[CJ_London]

Show your code since what you show is not valid

 

[moi]

Try

Is Not Null

Thanks bob fitz..

 

[moi]

Show your code since what you show is not valid

Thank you, it sorted out by bob fitz.

 

[ebs17]

WHERE DateField > 0

In contrast to the suggestion with NOT, index use is possible here, and index use should always be kept as open as possible in the interest of good performance.
0 corresponds to 1899-12-30 and implies that dates used are greater than this date.