Find the diference between a start date and today

[Natiq]

Hello,



I would have thought this to be pretty easy but I have hit a road block. I have a very small database and would like to be able to find out how many days something has been running. I have field called start and either need a way to auto-update a "Today's Date" field or just run a formula at form load the will calculate now()-[Start]. I have a calculated field called "total days" with the formula [Today's Date]-[Start] and it works just fine but you have to manually update the "today's date" field.

Any suggestions are welcome and thank you.

Natiq

[Ruegen]

Other than having the default value on the field (table) as Now() or Date() do you want this as code so that when you have an event like "open form" it makes the field [NameOfField] = Date()

?

You could have [NameOfField]= [TotalDays] on open form event...

Also in a query and rather a table (form record source) you can have a calculated field with any number of customized expressions/code without having to add it to the table...

[Natiq]

I thank you very much for the reply. Perhaps I was overthinking it as I had tried putting that formula in the "Load Form" event procedure except I had use the "Now ()" and it seemed to just fail.

Once again thank you very much for your help.

[Missinglinq]

Since this is a Calculated Field, it shouldn't be stored, so in the Control Source for your 'days running' Control use this

=Date()-[Start]

or better yet, use the DateDiff() Function:

=DateDiff("d",[Start],Date())

Linq ;0)>