How do you do date subtraction?

[emaduddeen]

Hi Everyone,

In my "Select" statement I have this:

Int((Date()-dob)/365.25) AS Age

I would like to do the same thing in VB .NET code. Can you show me how to do it?

I plan to do something like:

editBoxAge.Text = .......

dob would be stored in datePickerDob.Text

Thanks.

Truly,
Emad

 

[JuggaloBrotha]

You can use the DateTime.Today minus datePickerDob.Value to get a TimeSpan and from there it's a matter of calculating the years

 

[emaduddeen]

Hi,

I tried:

EditBoxAge.Text = Int((DateTime.Today - DatePickerDob.Value) / 365)

but I get this error:

Operator '/' is not defined for types 'System.TimeSpan' and 'Integer'.

Truly,
Emad

 

[JuggaloBrotha]

More like this:

Dim ts As TimeSpan = DateTime.Today.Subtract(DateTimePicker1.Value)
Me.Text = ts.Days.ToString

 

[petersgyoung]

For age calculation, you can also refer to my blog

 

[emaduddeen]

Hi,

Thanks for the help.

I used this based on your code:

        ' Calculate age.
        '---------------
        Dim ts As TimeSpan = DateTime.Today.Subtract(DatePickerDob.Value)

        EditBoxAge.Text = Int(ts.Days.ToString / 365)

I'm not sure why it works so I need to look at peter's blog and find out about TimeSpan.

Truly,
Emad