Date Difference from Now on sub-form

  • Thread starter Thread starter Gulf Coast Electric
  • Start date Start date
G

Gulf Coast Electric

I have a form named TimeCards with a sub-from on it named FTimeBillingSub
I need to show on the main form (TimeCards) the date difference between the
sub-form date (BillDate) and current date.
I tried this code, but it didnt work. The control is unbound that I want it
to show the date difference on.
The Label is named Text342 that I want to show the date difference.
The bound control I am referring to on the sub-form is named BillDate
Sub-forms name is FTimeBillingSub
= [FTimeBillingSub].Form![BillDate] DateDiff("d",Now(),[BillDate])
 
Back
Top