By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,776 Members | 1,351 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,776 IT Pros & Developers. It's quick & easy.

VB6 - how to find a specific date in Access database

P: 3
hello frriends,i am beginner in vb6.0 i want code to get the birthdate of an employee from records stored in ms-access which matches with todays date.
Apr 17 '07 #1
Share this Question
Share on Google+
2 Replies


100+
P: 149
hello frriends,i am beginner in vb6.0 i want code to get the birthdate of an employee from records stored in ms-access which matches with todays date.

Write the query to select the birthdate from the corresponding table and in the where condition match the birthdate with the current date.

ansuman sahu
Apr 17 '07 #2

Expert 5K+
P: 8,434
hello frriends,i am beginner in vb6.0 i want code to get the birthdate of an employee from records stored in ms-access which matches with todays date.
I assume you aren't looking for employees who have just been born today, so you may need to try matching on the Month() and Day() function. Um... I think there is also a function DatePart() which may be useful.
Apr 17 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.