Date Fields

R

Ron

I am fairly new at Access and learning alot here in the discussions group. I
appreciate everyones help that I have received.

I have a question. I have a form that has a date due field. I would like to
have a calculated field on the form that will indicate when the due date is
within 30 days. Also if this field can then count down the days to zero.

Thanks,
Ron
 
F

fredg

I am fairly new at Access and learning alot here in the discussions group. I
appreciate everyones help that I have received.

I have a question. I have a form that has a date due field. I would like to
have a calculated field on the form that will indicate when the due date is
within 30 days. Also if this field can then count down the days to zero.

Thanks,
Ron
Click to expand...

Set the control source of an unbound control to:

=IIf([DateDue]-Date() Between 0 And 30,[DateDue]-Date(),"")
 
Top