Counting Days between two dates in Days

[jennyp29]

Hi

Can you help me with this problem?

1. I have two date fields, one a referral date and one an action date. I need to find out all those records that have a time span greater than 42 days between the two date.

2. I also need to find out the number of days (if greater than 42 days) from referral date to today's date for all those records that have not yet received an active date

I am unable to do programming, so need to keep it basic, is it possible?

[MSeda]

Use the DateDiff function in your query to determine the number of days between the dates you can use an iif statement to insert today’s date where actiondate is null

DateDiff("d",[ReferralDate], iif(isnull([ActionDate]),Date(),[ActionDate])

see how far this gets you and let us know if you need more help

[NeoPa]

Use the DateDiff function in your query to determine the number of days between the dates you can use an iif statement to insert today’s date where actiondate is null

DateDiff("d",[ReferralDate], iif(isnull([ActionDate]),Date(),[ActionDate])

see how far this gets you and let us know if you need more help

Another way to write that would be :

DateDiff("d",[ReferralDate], Nz([ActionDate],Date())

Nz() is a very handy function that uses the first parameter unless it's null, in which case it uses the second. Excellent for situations like this.