Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access ASP
Access ASP Using ASP with Microsoft Access databases. For Access questions not specific to ASP, please use the Access forum. For more ASP forums, please see the ASP forum category.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access ASP section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old November 8th, 2006, 06:33 AM
Registered User
Join Date: Nov 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Select fields & calculating age

Hello everybody.

I have an access database and i'm programming asp pages to select records given some criteria. One of them is the age of someone.

In my database fields i have the date of birth. How can i accomplish that?

Another thing that i have noticed is that after finished my asp application i still have my access database locked (ldb file exists). How can i correct this? This is because the web server is still running?

Old November 26th, 2006, 06:16 PM
Friend of Wrox
Join Date: Jun 2003
Posts: 308
Thanks: 0
Thanked 0 Times in 0 Posts

Use DateDiff to get the age. eg: DateDiff('yyyy', BirthDate, Now())
Also - are you clearing out your connections and recordsets?
eg: Rs.Close
Set Rs = Nothing

I am a loud man with a very large hat. This means I am in charge

Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculating text fields jayman Classic ASP Basics 13 March 6th, 2006 05:27 AM
Calculating and filtering age based on date shawnm Classic ASP Databases 4 November 12th, 2005 06:08 AM
calculating a persons age Hudson40 Access VBA 4 January 26th, 2005 11:45 AM
Using Forum fields select fields on the fly hellosureshkumar Crystal Reports 0 December 17th, 2004 08:20 AM
SELECT LIKE on DATE fields borami Classic ASP Databases 2 March 16th, 2004 11:43 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.