MS Access_Calculate Number of Days

[Help4ME2]

I need to calculate the number of days between a date of birth and now. Using Access 97.

 

[HarleyQuinn]

Have a look at the DateDiff() function.

Hope this helps

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[Help4ME2]

i did., so.. if my field name is DOB, what do i specify - exactly.

 

[HarleyQuinn]

What did you try?



HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[Help4ME2]

DaysElapsed: DateDiff("d",[RecDOB],Now())

i am new to all of this- sorry-

 

[HarleyQuinn]

No worries, the syntax you've got looks good (maybe use single quotes rather than " if you're doing this in query designer).

I assume it doesn't return what you want?

If not what is the datatype of the [RecDOB] field?

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[ZmrAbdulla]

i did., so.. if my field name is DOB, what do i specify - exactly.

DaysElapsed: DateDiff("d",[RecDOB],Now())

DaysElapsed: DateDiff("d",[DOB],Now())

?????

________________________________________________________
Zameer Abdulla
Help to find Missing people

 

[HarleyQuinn]

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.