working with the now() function

[irishcrazymofo]

I have a field on a report called date open and a field called date sent.

I need to create as field that will show the diffrence betweent hese two. i know how to do that with the now() function. but sometimes the date sent field is not filled in this case i need to compare the date open to todays date. is there a way to do this in one field or will there need to be two. and how would i compare todays date with the date open

thanks in advance

 

[kalebson]

The difference as in the number of days difference?

Like a text box that has this

=Iif(Not IsNull([date sent]),[date open]-[date sent],[date open]-Now())

is that what your looking for?

 

[Rich]

It's better to use the Date() function than Now() in this instance

 

[kalebson]

Thank you Rich..you are right. I was just following the post hehe.