Adding 24 hours to an initial start date on a continuing basis

[LadyLyke]

I have a database where I need to track days of service for each client. I thought if I had a column for initial date of service I could create another column that would add an additional day to the date in the initial date column on a 24 hour basis. I've tried using the formulas bar but I've only confused myself further. Any help would be greatly appreciated.



Thanks

[June7]

Do you want to calculate the difference between the initial date and current date?

[orange]

??? What exactly are you trying to do in plain English??
Typically if you are providing "service", you have a start date and some sort of contract/agreement; and in the agreement is the service end date. And always a provision to renew service for a fee.

If you started service on Mar 1, it would seem that the time period between today's Date and Mar 1 would indicate the days of service.

[LadyLyke]

Yes June7. And to orange not every company operates that way which is why we need we need it calculated. I thought a 24 hour increment would work but I can't figure out how. Although just adding a counter sounds like a much better idea.

[orange]

If you know the startDate, and you know "today", you can calculate the difference at any time for reporting/informing. No need to store the difference anywhere.

[LadyLyke]

This is what I have in the Control Source Property Sheet

=DateDiff([“d”],[Initial Date of Service],[Date],Now())

I want the difference between the initial date of service and today to display but all that is displayed is #Name?

Can you tell me what I'm doing wrong?

[LadyLyke]

I figured it out. I did not need the Now()