The date of birth of an animal

[Guest]

Hi
I really need help it is for my GCSE Coursework. I need to find out the age
of an animal by only using its date of birth. SO basically i need to find out
how old the animal is each day. It need to be in months and days please.

How do i do it i tried an update query but it did not work i got a stupid
number of -3647 days.

 

[Randall Arnold]

You need a select query, not update.

In an mdb:

datediff("d",Now, BirthDate)

In an adp:

datediff(d, getdate(), BirthDate)

This will only return days, but with a little more work you should be able
to find an algorithm that produces months and days.

Randall Arnold

 

[fredg]

Hi
I really need help it is for my GCSE Coursework. I need to find out the age
of an animal by only using its date of birth. SO basically i need to find out
how old the animal is each day. It need to be in months and days please.

How do i do it i tried an update query but it did not work i got a stupid
number of -3647 days.

Well, if you did it in an Update query I hope you backed up your data
first!

Isn't this something your course instructor is getting paid to help
you with?
Why not ask him.