Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
How can i minus two Dates (LblExpirydate.Text - Label3.Text )
 
        LblExpirydate.Text = String.Format("{0:dd/MM/yyyy}", dataReader(0))
        Label3.Text = System.DateTime.Now.ToString(("dd/MM/yyyy"))
 

LblExpirydate.Text = 01/05/2013
 
Label3.Text = 01/04/2011
Posted 30-Mar-13 7:53am

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Start by treating them as dates, rather than converting them to strings:
Dim dt As DateTime = DirectCast(dataReader(0), DateTime)
Dim now As DateTime = DateTime.now
LblExpirydate.Text = String.Format("{0:dd/MM/yyyy}", dt)
Label3.Text = now.ToString("dd/MM/yyyy")
Dim diff As TimeSpan = dt - now
  Permalink  
Comments
hany1002 at 30-Mar-13 13:05pm
   
Great thanks
OriginalGriff at 30-Mar-13 13:08pm
   
You're welcome

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 325
1 DamithSL 265
2 CPallini 235
3 Maciej Los 190
4 Sergey Alexandrovich Kryukov 189
0 OriginalGriff 5,455
1 DamithSL 4,422
2 Maciej Los 3,860
3 Kornfeld Eliyahu Peter 3,480
4 Sergey Alexandrovich Kryukov 3,010


Advertise | Privacy | Mobile
Web01 | 2.8.141216.1 | Last Updated 30 Mar 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100