Date Difference from Now on sub-form

  • Thread starter Gulf Coast Electric
  • 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])
 

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