IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

New StartDate = "01/01/1900"




Satan (impatiently) to Newcomer: The trouble with you Chicago people is, that you think you are the best people down here; whereas you are merely the most numerous.
- - - Mark Twain, "Pudd'nhead Wilson's New Calendar" 1897
New The epoch start date is 1900-jan-00
No clue what will happen if you feed it in like that, though. (I left Excel behind at work ;-)

Edit: disambiguate month & day
Expand Edited by scoenye Aug. 11, 2015, 10:35:00 PM EDT
New That's why I used 1/1/1900
because I was getting numbers like "42221.00" in Excel. Subtracting that many days from today put it around the 3rd or 4th of January, 1900. Knocking off the 2 additional days made all of the dates in the spreadsheet match the dates in the SQL table.




Satan (impatiently) to Newcomer: The trouble with you Chicago people is, that you think you are the best people down here; whereas you are merely the most numerous.
- - - Mark Twain, "Pudd'nhead Wilson's New Calendar" 1897
     Trying to format a Excel column as Date from VB.Net - (lincoln) - (10)
         Does the case matter? - (Another Scott) - (1)
             just for grins - (lincoln)
         This worked, but it takes longer - (lincoln)
         How do you export/import? - (scoenye) - (1)
             The batch process has a program that uses a SQL Bulk Insert - (lincoln)
         Well, they won't let me use a varchar - (lincoln) - (4)
             The only way I can reproduce is if the cell contains a string - (scoenye) - (3)
                 StartDate = "01/01/1900" -NT - (lincoln) - (2)
                     The epoch start date is 1900-jan-00 - (scoenye) - (1)
                         That's why I used 1/1/1900 - (lincoln)

Got LRPD?
98 ms