Filter Data by Date/time (field)

[Sniper-BoOyA-]

Good morning,

Ive got a small "problem".

Ive got 2 values. D7 and D28. And i want to filter it by using a date/time field. Both D7 as D28 have their own date/time field, and i would like to filter it like this:

D7

Iff (Date/time field D7 = "";"";D7)

Same with D28:

Iff (Date/time field D28 = "";"";D28)

But when i run this query it shows an #error.

Any ideas?

 

[DCrake]

Are we talking Access or Excel here?

 

[Sniper-BoOyA-]

Access ofcourse. There are no queries in Excel

test: IIf([Drukdatumd7]="";"";[d7])

Only works when Drukdatumd7= empty.

If i enter a date, i get #error as result.

 

[JANR]

Try this:

test: IIf([Drukdatumd7]Is Null;Null;[d7])

JR

 

[Sniper-BoOyA-]

Try this:

test: IIf([Drukdatumd7]Is Null;Null;[d7])

JR

Yay it worked.. Thanks m8 !

 

[vbaInet]

I would be inclined to change it to:

test: IIf([COLOR=Red]IsNull([/COLOR][Drukdatumd7][COLOR=Red])[/COLOR];Null;[d7])

... because Is Null is built for the WHERE part of an SQL statement whereas IsNull() is a function used for comparison.