TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Bhavesh Vankar
761
1.1k
86.9k
Age find using DOB in textbox vb6.0
Apr 12 2021 8:31 AM
when i use below query to find age using birth date it generate error as per below...
error
THE CONVERSION OF A VARCHAR DATA TYPE TP A DATETO,E DATA TYPE RESULTED IN AN OUT-OF-RANGE VALUE.
my code as per below..
i want to find age and display in textbox using entering DOB in textbox....
i have implement as per below... whats wrong kindly suggest....
If
rs.state = adStateOpen
Then
rs.Close
rs.Open
"Select DATEDIFF(YEAR,CONVERT(datetime,'"
& txtBirthdate.Text &
"',103),CONVERT(varchar,V_ISSUEDATE,103)) from MASTER_NEW"
, cn.Conn, adOpenDynamic, adLockOptimistic
txtAge.Text = rs(
"V_AGE"
) &
""
Reply
Answers (
11
)
Sorry this a Python question.
Circle's centre follows parabolic trajectory