Digital Workshop

Welcome to the Digital Workshop Message Boards
It is currently December 23rd, 2024, 3:31 am

All times are UTC [ DST ]




Post new topic Reply to topic  [ 4 posts ] 
Author Message
 Post subject: Age from DOB
PostPosted: October 2nd, 2006, 2:07 pm 
Offline

Joined: January 23rd, 2006, 2:57 pm
Posts: 55
Location: Belfast
Opus: 9.5
OS: Win 7
System: i7 8G ram
I have developed a database pub with peoples detials on it but I cant figure out how to get the age of someone from their DOB. Tried Using SYSTEM_TIME_YEAR etc and have broken the DOB into 3 variables for day month and year to try to compare them and get the age buy my scripting is poor(are there any scripting classes in Belfast???) so any help would be great. I think its quite easy but obviously Im doing something daft. Also when I do a search for Names for eg I can get them ok but have to view them one at a time via next or previous is there a way to show a list of the records found within opus or can i even put all the found records into a new access file and open it. Hope you can read to the end of this without dozing off.
Thanks
Paul


Top
 Profile  
 
 Post subject:
PostPosted: October 2nd, 2006, 6:00 pm 
Offline

Joined: November 11th, 2004, 1:43 pm
Posts: 172
Location: Buckinghamshire, UK
see was already dozing off, just about to ask what database you using....
Access I can see, so any microsoft users, this is for u...
In Opuscript, believe you will use getTime(), havent tried it myself but have a go with it...


Top
 Profile  
 
 Post subject: Age from DOB
PostPosted: October 3rd, 2006, 7:00 pm 
Offline

Joined: November 3rd, 2004, 6:44 pm
Posts: 59
Location: Ipswich, UK
Paul

In Acces you could create a calculated field called Age from a field call dob using the formula below.

Age: ((Date()-[dob])/365.25)

Hope this helps

Regards

Clive Cartmel


Top
 Profile  
 
 Post subject:
PostPosted: October 25th, 2006, 12:17 pm 
Offline

Joined: January 23rd, 2006, 2:57 pm
Posts: 55
Location: Belfast
Opus: 9.5
OS: Win 7
System: i7 8G ram
Thanks for the helpful replies.
It has taken me a while but have solved the probs.
Many Thanks
Paul


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 4 posts ] 

All times are UTC [ DST ]


Who is online

Users browsing this forum: No registered users and 42 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group