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...
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...