Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Storing a date into its simplest format
Message
From
30/01/2008 18:23:10
Mike Cole
Yellow Lab Technologies
Stanley, Iowa, United States
 
 
To
30/01/2008 18:18:18
General information
Forum:
ASP.NET
Category:
Coding, syntax and commands
Environment versions
Environment:
VB 8.0
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01287307
Message ID:
01287349
Views:
5
>>You have to add the ticks to an existing date. What are you using at your token date?
>>
>>Here is what I was thinking:
>>
>>        Dim tokenDate As Date = Date.Parse("1/1/1900")
>>        Dim result As Long
>>
>>        'This is the value you would want to store
>>        result = Date.Now.Subtract(tokenDate).TotalSeconds
>>
>>        'Convert the stored value back to a date
>>        MsgBox(tokenDate.AddSeconds(result))
>>
>>
>>Make sure you store your result as Long (Int64) otherwise you will get an overflow error.
>
>This is not working. The initial date I have is not always the same after the dual conversion. Sometimes, I have a difference of one second:
>
>
>        Dim lnResult As Long
>        Dim ldTokenDate As Date = Date.Parse("1/1/1900")
>        Dim ldDate As Date = Date.Now
>        Dim ldNewDate As Date = Date.Now
>        MessageBox.Show(ldDate.ToString)
>        lnResult = ldDate.Subtract(ldTokenDate).TotalSeconds
>        MessageBox.Show(lnResult.ToString)
>        ldNewDate = ldTokenDate.AddSeconds(lnResult)
>        MessageBox.Show(ldNewDate.ToString)
>
I wonder if it is rounding seconds.
Very fitting: http://xkcd.com/386/
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform