Re: Calculating Difference In Time For Age

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Allen, Thanks for your help, and if you are reading this....Thanks Mr.
Steele, your duration calculating code works real slick! As you may read
below, I am trying to automate the import process to comlete my task.


"Allen Browne" wrote:

> If the source date is coming in as text, you can parse it with Left(),
> Mid(), etc, and convert it to a true date with DateSerial()
>
> This example shows how to convert text such as "06/30/2005" into a true date
> (assuming a field named "d"):
> DateSerial(Right([d], 4), Mid([d], 4,3), Left([d],2))
>
> You can use something like that in the query design window in Access. Either
> type it into the Field row, or into the Update row to populate another true
> date/time field. (Update on Query menu.)
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia.
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "Jeff C" <JeffC@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:E0BEA088-56E4-4BA4-B46A-774F89417825@xxxxxxxxxxxxxxxx
> > Actually my problem is probably that I have not done anything with Doug's
> > code listed in the article.
> >
> > Knowing that one of the Ten Commandments for Access users is to "Never Use
> > Code" that you don't understand, and since I do not even know what to do
> > with
> > it (I might guess that I paste it into a new module and name the module
> > Diff2Dates), I guess I am just going to be out of luck with this report I
> > am
> > creating.
> >
> > What I have is software which will print a report to a txt file of all the
> > tests for the quarter (about 4000). Excel nicely opens this, I save it
> > and
> > then I import the data into an Access table. From there I can do alot of
> > what I need, but I need the age of the neonate too, and I have found that
> > the
> > date and time for the two fields is imported as text, which I lose when I
> > change the field design to Date/Time.
> >
> > "Allen Browne" wrote:
> >
> >> Access does not have a function to do that, but MVP Doug Steele has one
> >> here:
> >> http://www.accessmvp.com/djsteele/Diff2Dates.html
> >>
> >> "Jeff C" <JeffC@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> >> news:243494B0-75DA-439E-95C1-C9A6D45CD299@xxxxxxxxxxxxxxxx
> >> >I am working on a report for a neonatal unit which requires the specific
> >> >age
> >> > of the newborns through a series of tests. I have two fields each
> >> > holding
> >> > a
> >> > date and time, one field for the birth date and time...the second for
> >> > the
> >> > test date and time. They are formated as such: 7/10/2005 15:35.
> >> >
> >> > Can someone help me with a formula I can use as the control source of a
> >> > text
> >> > box in my report that will return the difference (age) in days, hours,
> >> > and
> >> > minutes? Thank You.
>
>
>
.

Relevant Pages