Hi guys,
I am trying to store a series of dates in to an Access Database
The same code works fine if its printing it on screen or even using it
in a SQL Statement but when it adds it to the access table
It gives me a float # which is crazy. I tried to put it in as a date but
that would give me some date in 1899, so I tried to put it in as a
varchar and its giving me the weird float #'s
Dim datecount As Integer
For datecount = 0 To DateDiff(DateInterval.Day, CDate(Request("sd")),
CDate(Request("ed")))
Dim newdate As Date = DateAdd(DateInterval.Day,
datecount, startdate)
mySql = "INSERT INTO tmpRptDLG" & randomfilename & "
values (" & _
newdate.ToShortDateString & _
", 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)"
myComm = New OleDb.OleDbCommand(mySql, myConn)
myComm.ExecuteNonQuery()
Next
myreader.Close()
myConn.Close()
This is what the db fills:
tmpRptDLGDailyCallsZKVWQTFSHN
CallDate
7.98004987531172E-04
6.65004156275977E-04
5.70003562522266E-04
4.98753117206983E-04
4.43336104183984E-04
3.99002493765586E-04
3.62729539786896E-04
3.32502078137988E-04
3.06924995204297E-04
2.85001781261133E-04
2.66001662510391E-04
2.49376558603491E-04
2.34707349273874E-04
2.21668052091992E-04
2.10001312508203E-04
1.99501246882793E-04
1.90001187507422E-04
1.81364769893448E-04
1.73479345115472E-04
1.66251039068994E-04
1.59600997506234E-04
1.53462497602148E-04
1.47778701394661E-04
1.42500890630566E-04
1.37587066815719E-04
1.33000831255195E-04
1.28710481859866E-04
4.48877805486284E-03
2.24438902743142E-03
1.49625935162095E-03
1.12219451371571E-03
8.97755610972569E-04
THanks
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor --------------------~-->
Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life.
http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/saFolB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
