Problems using Dtpicker in VB6

[virusingh]

q.1How to use DTpicker in vb6 add , difference, between two date e.g
one employee date of birth is 15/1/1987. and how we will use dtpicker to calculate its retirement date after completion a service of 57 years.

q.2 How can i calculate the current date in today i.e. 20/02/2008 from his date of birth i.e, 15/01/1987. How many year he complete i.e, age as on 20/02/2008.

q.3 can i generate automatic No. i.e, serial number in a given sequence. after adding a new data in visual basic.

[mafaisal]

Hi,

U can Use DateAdd,DateDiff Functions For this,
in its interval means adding day or month or year by "d" or "m" or "y"

U can Use slno by Getting max(no) +1

Faisal

q.1How to use DTpicker in vb6 add , difference, between two date e.g
one employee date of birth is 15/1/1987. and how we will use dtpicker to calculate its retirement date after completion a service of 57 years.

q.2 How can i calculate the current date in today i.e. 20/02/2008 from his date of birth i.e, 15/01/1987. How many year he complete i.e, age as on 20/02/2008.

q.3 can i generate automatic No. i.e, serial number in a given sequence. after adding a new data in visual basic.

[mafaisal]

Hi

Also Check these Link

Check this

Faisal

q.1How to use DTpicker in vb6 add , difference, between two date e.g
one employee date of birth is 15/1/1987. and how we will use dtpicker to calculate its retirement date after completion a service of 57 years.

q.2 How can i calculate the current date in today i.e. 20/02/2008 from his date of birth i.e, 15/01/1987. How many year he complete i.e, age as on 20/02/2008.

q.3 can i generate automatic No. i.e, serial number in a given sequence. after adding a new data in visual basic.

[jimmylee]

 
dim intDateDiff as integer
 
           intDateDiff = datediff(format(dtpPicker1.value,"mm/dd/yyyy"),format(Now,"mm/dd/yyyy")
 
 
 
 
 

[debasisdas]

To reply your 3rd question.

Find out the count of number of rows and increment that value by 1 to get the next serial number.