Date Difference Question

D

Dave

I have (2) text boxes on my main form, named StartDte and Text472.
StartDte shows a date value and Text472 shows a numeric value, i.e. the
number of days since the Invoice was created.



StartDte Name
StartDte Control Source
m/d/yy Format
_______________________________________________________
Text472 Name
=IIf(IsNull([StartDte]) Or
IsNull([Text463]),0,DateDiff("d",[StartDte],[Text463],0)) (Control
Source)
This value is expressed in a numeric value, i.e. number of days

Days since job started is the aim here...


_______________________________________________________
Both are Text Boxes;
Text463
=Date() Control Source
Format Long Date
_______________________________________________________
Now, how can I determine the number of days from Text472 and Text463 ?
Similar to Text472's code, I think...

Days sinve it was Invoice is the aim here...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top