datediff in report?

[EgWeb]

Hello,

I've got a report in which each record has a "startdate" and "completiondate". Can I calculate the number of weeks between these when running the report?

Thanks,
Andy

 

[CosmoKramer]

Andy,

Add an unbound text box with something like this as the control source:

=DateDiff("ww", [startdate], [completiondate])

Hoc nomen meum verum non est.

 

[EgWeb]

You are awesome, Thanks!

 

[EgWeb]

One step further...

Ok I set a control to this:
="Weeks: " & (DateDiff("ww",Now(),[LastContact])*-1)

Can I put a condition into place that if "LastContact" has no value that it would be blank?

Thanks!
Andy

 

[CosmoKramer]

If you mean that the whole control should be blank, it would be something like this:

=IIf ([LastContact] Is Null,"","Weeks: " & (DateDiff("ww",Now(),[LastContact])*-1))

Hoc nomen meum verum non est.

 

[EgWeb]

Cosmo, you're a genius...

Why the 2 I's on the IF though?

Thanks!
Andy

 

[CosmoKramer]

The IIF function is an immediate IF, it will return one of two values based on whether an expression is true or false. It has three arguments. The first argument is the expression to test, the second argument is the value to return if the expression is true, and the third argument is the value to return if the expression is false.

It's a slightly more compact method than using an

If Then Else....

statement....

Hoc nomen meum verum non est.