Justus thank you for your response but I was a bit mixed with you code there are ambiguous types this is what I made it. Dim dpReturn As Date = CType(Me.dpReturnDate.Value, Date) Dim dpDue As Date = CType(Me.dpduedate.Value, Date) Dim MyDifference As TimeSpan MyDifference = dpReturn.Subtract(dpDue) ' find the number of days apart TextBox1.Text = CInt(MyDifference) now watch this CInt(MyDifference) can not be type casted. ahaaaaa men this thing is holding me up my previous code in the project looks like this stDate = CDate(.Item(3).ToString) ' this is a date stored in a database being converted to date dtDate = DateTime.Parse(stDate, Globalization.CultureInfo.CreateSpecificCulture("en-CA")) amount = DateDiff(DateInterval.Day, Now, dtDate) * fratepday ANY SUPPORT HIGHLY APPRECIATED On Thu, Aug 25, 2011 at 1:32 PM, justus <mutahijustus@gmail.com> wrote:
Try this
Dim dpReturn As Date = CType(Me.dpReturnDate.Value, Date) Dim dpDue As Date = dpDueDate.Value Dim dpReturn As Date = dpReturnDate.Value Dim dpDue As Date = CType(Me.dpReturnDate.Value, Date) Dim MyDifference As TimeSpan MyDifference = dpReturn.Subtract(dpDue) ' find the number of days apart
On Thu, Aug 25, 2011 at 1:06 PM, MICHAEL AKUNGA <michaelakunga@gmail.com>wrote:
I intend to get the difference of days between two given dates unfortunately all methods have used are firing an exception especially on type casting a string to date so far have used *DateTime.parse() and DateDiff() anyone any idea*
-- MICHAEL A. AKUNGA (+254) 0726 174 815 michaelakunga@gmail.com michaelakunga@yahoo.com
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
-- Justus +254 724 46 55 99
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
-- MICHAEL A. AKUNGA (+254) 0726 174 815 michaelakunga@gmail.com michaelakunga@yahoo.com