Query, between, Null, IF, And .........UGH

[Kevbro7189]

I have a query that is looking at 3 dates, Ticket date, Issue Date, and
Return date. I want to know if the Ticket Date falls between the Issue and
Return dates. My problem is with entries with Null Return Dates. I want the
query to look at Null Return dates as Now or grater. This is the expression
I have come up with so far but it doesn’t work.

Between [Date issued] And (If(IsNull([Date Returned])),Now())

 

[Allen Browne]

Try this:

Between [Date issued] And IIf([Date Returned] Is Null, Now(), [Date
Returned])

 

[Kevbro7189]

Thank you works GRATE!!!!!!!!!!

Try this:

Between [Date issued] And IIf([Date Returned] Is Null, Now(), [Date
Returned])

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I have a query that is looking at 3 dates, Ticket date, Issue Date, and
Return date. I want to know if the Ticket Date falls between the Issue and
Return dates. My problem is with entries with Null Return Dates. I want
the
query to look at Null Return dates as Now or grater. This is the
expression
I have come up with so far but it doesn’t work.

Between [Date issued] And (If(IsNull([Date Returned])),Now())

 

[scubadiver]

Grate ???

or

Great

Thank you works GRATE!!!!!!!!!!

Try this:

Between [Date issued] And IIf([Date Returned] Is Null, Now(), [Date
Returned])

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I have a query that is looking at 3 dates, Ticket date, Issue Date, and
Return date. I want to know if the Ticket Date falls between the Issue and
Return dates. My problem is with entries with Null Return Dates. I want
the
query to look at Null Return dates as Now or grater. This is the
expression
I have come up with so far but it doesn’t work.

Between [Date issued] And (If(IsNull([Date Returned])),Now())

 

[Allen Browne]

It's okay if it just falls through the cracks.