[")rwrys.XYF/CST~~}T~~P666666696FX(BXBCElBCS}T~~}T~~","FromOADate."," Excel interop dates are stored as integers. It is possible to convert them to DateTimes. We use FromOADate to convert OLE Automation Dates to real DateTime values. We examine the FromOADate method. ","Input OLE date:","\n\n39456\n39482\n39484\n36526\n36557\n39270\n\n","Output DateTime:","\n\n1/9/2008\n2/4/2008\n2/6/2008\n1/1/2000\n2/1/2000\n7/7/2007","Example."," First, you can use FromOADate as a static method on the DateTime type. This method receives one double value as its parameter, and the returns a full DateTime. This will convert those five-digit integers to the regular DateTimes. ","Next: ","We show some example calls and output. With Console.WriteLine, we print the results.","ins","class","adsbygoogle","data-ad-client","ca-pub-4712093147740724","data-ad-slot","6227126509","data-ad-format","auto","ins","class","adsbygoogle","data-ad-client","ca-pub-4712093147740724","data-ad-slot","6227126509","data-ad-format","auto","C# program that uses FromOADate","\n\nusing System;\n\nclass Program\n{\n static void Main()\n {\n var arr = new string[]\n {","\n // OA Dates in early 2008.\n ","\"39456\","," // (1/9/2008)\n ","\"39482\",\n \"39484\",\n \"39493\",\n \"39496\",\n \"39497\",\n \"39501\",\n \"39506\",\n \"39510\",\n \"39513\",\n \"39515\",\n \"39521\","," // (3/14/2008)\n // Different series starts here.\n ","\"36526\","," // (1/1/2000)\n ","\"36557\","," // (2/1/2000)\n ","\"39270\""," // (7//7/2007)\n ","};\n\n foreach (string b in arr)\n {","\n // We must have a double to convert the OA date to a real date.\n ","double d = double.Parse(b);","\n\n // Get the converted date from the OLE automation date.\n ","DateTime conv = ","DateTime.FromOADate","(d);","\n\n // Write to console.\n ","Console.WriteLine(\"{0} = {1}\",\n b,\n conv.ToShortDateString());\n }\n }\n}\n\n","Output","\n\n39456 = 1/9/2008\n39482 = 2/4/2008\n39484 = 2/6/2008\n39493 = 2/15/2008\n39496 = 2/18/2008\n39497 = 2/19/2008\n39501 = 2/23/2008\n39506 = 2/28/2008\n39510 = 3/3/2008\n39513 = 3/6/2008\n39515 = 3/8/2008\n39521 = 3/14/2008\n36526 = 1/1/2000\n36557 = 2/1/2000\n39270 = 7/7/2007","It shows a sample array."," Above, the array is simply an example of OADates you might encounter. Typically the doubles will be somewhere in the 30,000s, but you may encounter outliers.","Next,"," it loops with foreach through each example string. We use a foreach loop to look at each number in the array. These numbers would be typically be extracted from Microsoft Excel Interop or some databases. ","Foreach ","foreach","Values must be double types."," The FromOADate method requires that it receive a double value. For the custom code above, we convert the string to a double. You may not need to do this. ","Double ","double","Finally: ","We use the static DateTime.FromOADate to turn the double into a regular DateTime.","Static Method ","static","Summary."," We used the FromOADate method on the DateTime type in the C# language. We saw the input and output. This is a tricky topic and this article serves as an adjunct to my other Excel Interop article. ","Excel ","excel","Note: ","These methods are mainly required for legacy XLS files, which may be replaced with more robust XLSX XML files.","ins","class","adsbygoogle","data-ad-client","ca-pub-4712093147740724","data-ad-slot","3679700504","data-ad-format","link","ins","class","adsbygoogle","data-ad-client","ca-pub-4712093147740724","data-ad-slot","6227126509","data-ad-format","auto"]

%iVBORw0KG;)NSUhEUg?ANw?ABUCAM?ADeZ6kG)YFBMVEX::81Nf4d4P17iv3UmX95edvbCf1K0P6pavMxir5kpr7vsLf2SqYlCiqpSn1MUj17jH38VT7+KnBvCnr5CsmJib:/7:v77qbP6sbf+9faCfyj49HL:/3:f7+/v6w/yUo?ACZUlEQVR4Xu3a187qMBAEYFzSC73+7f3f8sQww@I2Y0UH+xo54qLkfEnQOvIrFbni10XY1nby3mFRFHm56wLOvocU5mfS8HJJaYyP5aFszGV+VmzcOuYyvwUvERSjgAnOMEJTnDlH3JrahbOD0uirNBD1DiufCmXc+Lg01NwZTI4pCZxfs8qahziUKqwzV1nSZz230sSpx7tsigpHAwKzHlxbjMO1xA4vPcdUieEq/HREbhsIGiFnQTAIbPioPzTBM4Oggy/EMYo?4hcIgOhqsJXD0IrngMqVPDaQKn3Ga1zpykSQdnCdz7k+Ntdlymh9gAuPqOI7ZQv6yjZ8VhFFj4ZsVlnFHQDICmHJI5yjUALsQo0Io1xG8Y3sXVUbLIcPTxiz5RKX9YUiM40Dzvo2fLTBcLxWV45E@J0/ighOc4AQnuPRveeR+LuWbVbkTR34ZfyP4jaX88UgkEonktNtuzFg2290pbJnfnmr7NnS+T4HL/Pak7Awnu8BlfntStizcNnCZ356UDQu3CVzmtyfF8BK2zG9/Hic4wQlOcPnxJTmJ69GsxnCuhvRDoXpd/h2HdX36BHDw9EvDPRc++DfJu/+Oy031WK8ncAg+gnGc/yruzcFv+R33vm6fBi531c7s8XKBuNx0zsXEzT8KgEPmwkF0bJ1xz8EhVRq4ryOIebU8nJ92C8S1z/0ycXk15JAG7jnhTMUfBe3ga1PAdQ/bF3D8UZACbo/p/SEcaJ4359kyx+Gk7aecLVPBGczxJeKg6kLh5ElccIITnOAEl/4tj9zPJXyzKnfiyA/jXwQ/gcv89j+gsyv28aCq3Q)BJRU5Er@ggg==%iVBORw0KG;)NSUhEUg?ALw?AByC)ADMwOSz?ACe0lEQVR4Xu3csY7kMAgG4Lz/86Wkp6ZAokDy6RTfodVsTDSaxPy7/uux9a0LZpkEb20YNzNVEWYmItr/hYiYWcS8Tcw2cKv8DTPtoxCzqFfC+wGXgCchYlGvgDfp9MBd/xNsIj7otL8XHwC8x14Sq04/Yine4tRvwEvP6ypqPXp+dgneY+nbaZPwHscOh7eww+HDjoL/uJ1m4D3scPjYFw8fawDxUWjw8LErFP7TB7/z0/jYFA8fB4+Il1iQh47UwF:fvrfLPV/t0WEj+52Ev5yjWc96y/MNNrdR/EX6yRZuxb3Z/Ge10lu1/MsPm9auZXFS09iL4n3DE+tLD5vQrQsPi+U1ArjJcELAv7Og/eeAT4+cor3r2lbVPk7Sk30ODeEt3R/QcZ7YXxWbKgB47kyPis2;y3ynhP8K00frw9lcbbD8bz3fiFJ0S8jvEyCb/wioy30nhZ+Kz/Mz3CPa8S0h7hI9+AtMeOeIb3cBRswGO7UviFfwO48Au/8Au/8OhfUgu/8EkzUhqvNfELr8h4+cV477EuGvSw0sPnPaz06BHbDOJHp/UrMf6TkYVfD9RagndkvCI/vpfSeAN+9yDbn0rjPdnfEPCC+JpWS/BUGJ8PGWldfH46XBifzy1oXXw+qkOF8dE1wr2Cful4uC7epQdu7OLimBRpRfzlmkDiw1kjNRFmmjehto9DLJZNeT2P1zfG66jKbKAjDzbGCkS8Iw/zxhJAfGyLiI9aj4iPRYg3ToQeEB87EyLepQcLnyzEwIceER8VEwT/6fu0JuKDzwSA/yifWGbhIxb+y2wWm9DDJnc+UtE7HwOfXOTB/KX1o37bppq3efkDT4lpi2pYKzI)ASUVORK5CYII=%iVBORw0KG;)NSUhEUg?ANY)3CAM?ABHJUQ7)MFBMVEX::7/f7y/f+38v:6en/1dX/tbX/xcXl+v/U9:G9f:qKiq8P+U7P+e7v:lJQSDb6d?AEaklEQVR4Xt2Z27KiMBBF050bN/X:3aQiBvZoeMZHoYz+8myKYtFeuWCDomfcY30n3EXTXh8xtnp7p+5KlbcYYXGYE1rCpZeFCvtsBpdOPiSFe6qXfjYJTWwlgBt+AVqteXSfgnQ/MXVSl/Jpd2Svu/6oUQvrVZ24zdy6RrXlUHrr4mFMcosV2Pc+jnXxArAioZcRj/qldUaPwjtSEzPi0RnMFWpFrcJIea0qpvyZ1GEfn77laieU8tZcm2IQ17ZRVXFKurzi1VZZAzLWEu56G13XN0VPO3ktNvZ628lvUP6W4mHWkBhuRgrJDA4ETGLQusHCERFSgvDafwknvaMNXRbrAEIhDqwWo7lYiw8+tAsLsyMheF8Um3Jq90hM5ZXh3QvhLtDbq90rJYpV+3G7KKNlYo2i5nCToO0YA0OkZVBifRWUYvkOoFFHVoFL/bBbzgNtQrWpIZctlok11ksfWGllOKcMCfDrtdw7SBKALpiddX5gUFZLVMuaqK43LlRLB22T6xgQS5Wa8XqDbkMtYjSwsrhxaNyUFzXNEcZ0fUL+o6C1HK6YEGuDYU21aKeJCwwoaAq9aKUHQgNF83m1HN0UcHy1so12GoBMx1hZdnte7mI/WLXMRY8qn9JU9dCBayaXJOhli1XvTu103pxhlqwXBurIpeQWndgcdMJmpLVYs42lhxhPY8sNSzMhcn4eVILWDRF0BRCallyHeCWNuPi8AywQsRed4dFcrFaHlgkV0stksvAkjaW908sLVv68cFJhnGkFrBYLlstastjLEFBD7A8sIzdU02uulo7LIVchlqP9M5IpIyl2j3dKfaohSVExVgsV9gYr1Usd3/LBbUmqHWcaGAtFs/xQ3+ANc1Y5XXA2MJiufLGeJ2pgFWRC2oNEOY4+RjrSdXCWmtxA7LsC2HRoVxQq2BNwCK5DLU4LBe1+3T/Civtl2rCIrnkozOKWpjlSK6KWlZCC+tuN2FRawQFY9XlglqMxXKxWtnEiuexeAlhLJZrq5bTwQOrJtdeLdg8pm1ILsIqE6EvC66FxSXG4pVlhKkL1gQslmt6q9XZG6XMcrE+iJzDYrneH2TFmqlWLJbr/UH2agk9NiI4jZVbWLDw47F2dSzMf/5IrfHgsUULCzFmQlmVQS0kPiOw6VCr9wXr7hBsBBFWKxvn13NYur3ZGGJODyRL+0/RdXJ63raQXIipFst1HiuaSwjLhQh2TrhxlqupFst1AgsLl43FcsE9wiK5EG+oRXKdwPpiuIIhF3ZOwLLk6ltqASH/Pdb9NVzmoh8suXAoYSyWC8X0CtuSUwmwrKudVIoz07C+ognb7hpzCKmOJTgY4bzfa+dvVSzxc96d6P5BQiyPKYZCEmLkR8TLmqis/8L7OeoQ3slfO5m8NjNArSuHNbVzx6HkwuG38XYUr9IuHajF+cVqpZ+p5f9PtW7/pVrdL1EL5/2vgvP+tTP+TK3pd6gVfqaWXlwtfk1jhl/TXDsxlcQvsXxJ75A/ZMHNEnLfXgI)ASUVORK5CYII=%iVBORw0KG;)NSUhEUg?AG4?ACCAgM?ADasxWR)DFBMVEX/6Nn:/+VlZX29va5ksB5)SElEQVR4AWPACZj/f0DmjkqOSjKtQgcLyJccZiEE9SOmP8mXHEaBMBoIo4EwGggryJccvvVKKAogTnJUclRyVHLklgmjkqOS?LWyrsxEHLD)AElFTkSuQmCC%iVBORw0KG;)NSUhEUg?AMg?ABPCAM?ACZM3rM)GFBMVEX::w+/6Ep/SrxffC2Png+f7W5vtRgvA58pkI?ADDklEQVR4Xu3Z626rMBAEYM/e8v5vfBo1ZuQe1kBLAEfMz7SS82nJsrbLCXm8ssO/MTfkhtyQ03NDbsgNuSGh8gUSUQwN0QejGBjSJgaHMPEpEBkcwtinQGRUiKiFe8gkwaAQf2WS2OAQrxAdG8KSyK4QLnQYxD4FEoNDADxd4I/kbEi+9KpviE+BlI+BYDPEVJ5GEY2BIdBmsLFRISGPNoKrQDa136CAkotAbAMErAejBISKfNFE1OJwiG6YtbS7u7SGeTQEG4ZGTABRVWFJqDwNwoclliFaGeHPaJWAjuMhEd/PdHWIL0Mk2csYHQdCkigWIGzU+nNwVv7tfEgsQdjfzGvY8JQAETkRor4M0Wr2GpkgfES/iWHnQMQTSPITAQBCHiXoqDkYwuXLBsg3DIRYhfiZEDFfCcnCxrwGAlOpR1L4NcTMVFVE6iiu4c+ghfgrDS6LTEZdhkCTbrkR4knKXyFsaOhBLJlw9oLgb5BKYmUxD7HlY2chcDsE5S8QJQT91WPFnYbQtxmCshdk5ZDTRuYnus0QoKSQ3qjFTBD0IZa8/62FVEmUgjCdHxJQ8zJQsRBC4tcQTv7t+Czdx4+QnaL8Fm2wEoLG0W4EGJd3Q+yRlAQsVhdi6VWAFcb13RBnm7IXIcxMlRBLIFlJ5/bZcHkzJF2AEO1ByO1eBcCjBcjeEFgCaVrmSgiAFOIuzRng7hCXDDIRtQNp3v9zVwGEeD1YUge8Zj9IImHLZPOXHgTdqwBPsiMkkSQtM4dMtMMhXEF/UkS0FOgWCPoHz3grhCuY1r2MqL72ZHDZD1IOgrSpkNgRUt4NKcghrjkk32lUvnQWQtkfUtKSu3vIg1HrQCy9Cm?cDB/Q1JI0/ytVeYH:zk8GB+O4M1PfP/KnFoPCEAqgDAlubvP9:yjfLdbIGIpMEzcGQXAmCZQjSrS5KuSgFIGRx6hS/FoQ9E5k0OQ4iZIzA3WYc5uNA2BBiph7uZbCA+/TmQAVDQtx5rWDuhIwnYcZ05LPagMHoBWFGrweD0cvB8C7gaox/oFZvpHcPXdQ)ASUVORK5CYII=$/9j/2wBD?cHBwcH.@.@.@.@.@.@.@.@.@.@.@.@.@.@.@.@.@.@.@.n/wQARCADCAQoDACI?RE?hEA/8QAW?B?MBAQEBAQ)))ECAwQFBgcIEAE?gEDAQQHAwoEBw)?AQIRAxIhMQRBUWEFEyIyUnFyQmKSFCNTgYKhorLS8DORscEkNENzwuLy/9oADAM?AE?g?PwD+kAQJSIECRVIYShUFsLJUykMLCqRVIhKQSgEJEAJEYMAk)))AEK56pRMoTBlEyrMwiReITuWmWM2jMJ3Cdq02RuYzdG9K+1vFk5c8XXi4TV0ZTljFloshnMNMphXKciFhBlKqQyZBIhIg)))ABVWVmNdXTv7mpS302rP+iF4iUyztK1mF5S1rCJtzHzLWYWtzHzReycNtnRe11N7C12c3XireNJ2RdpF3BF2lbk1VnSd9btYlxUu6K2ZzDC1XSvDGsrwhhMNBESmZFTCURKRVICRIhIg))?ABV+ddom1Jfoz43tPZuvDbQmImXreirxS2pnv2/8Am8OO3dp0/d1NSvyvaGtfTPbK/wDVn9qtZ/1qx1uzzzw4L6c5d8V079Yq+kro9m1ozOnSf2XvaXpnWvekWik5vWPdx9r6nqz22Ph/ys+N0aT6zT/7lP5nv8sdXS04mMQ5e09l7PSY21rHs/ZehPaaW8YR62vi4OUxKm2HN6mnc763z3t6XcGnPV00lSYY3o76WdNLOGjrpLK0OPVq6a58W1c8Oetpb1mcwzcloWxaI65/+V7RmMKbrRHPX/1WtnHHVDKesIiLezGfnhO20xMTPfWY9qysWt7MY6+Pktuvie6Ymv2e7cknK+20zPP8RWLcRPPPxfdV3XzMRHHd7Nl62nHMf3tFZzhZLOJtjvznn2fdTEznnMccx5iuFxnutiuI+czWyZm2J8unshhcRmf3GZEJEHeCRHI.?AQ8nW0N0Tw9ZjNLTHQzhrpXmk5h8t2jslpzik/heXfsV8+5P4bPtb6c+Dmto8uiuvMPX0e33pD4/T7HeL0nZfi9fs2+J6s9nvH2J/C9mNDmJx3tL6ZbXmV9Xt83mHzs6V/gn8Nmc1mvc929Hkdor+ct+z/KtW2Wujrb5x91GnHV0Uhno14n9l1VoWnlGrbqvSHZRhSrppDG0uK8tqy2rPTzY12tq4zHHyZuOy26McwtaZiMxGZ8FfYmPJa0xjOMx4IZ+CIvHHjP8AUtv4zET1rGFImvH7o+fHctmmOI4zicVCY8lt8ZmMTx1XraLR4fNnupEz4459leu20ZgVmPJO7iZwTeMz5d/71M0xOa4jPPs+9/kvE06R4Z93uSjHkmLeXfhKldsxExGInmIXFZSAI))Q?iYjwSgSztWlYmZjiOZ/U8PX9JWpbPq4mnfG62/H1e69+1YtExPSYxP63g63orU1LY9ZSNPPM+1vx9Pur02Z9p29lnRzPrZ/FuduympWt6z7N4ras+U1zV5uv2W1rzMTD14pWla0rGK0itax5RxVnauZItieF9LVmkzNZ4+94PK0dG1N2Y67cOiKOrYtFEzbLS2tmcyxrRvWqYo0iqkywtZEVhrWIzCsU6r7eiGUz5m2OibYxz0V2cYj+/ZWvGYwhTw5RFa+zMd3T9adtYifP7ykVnNcznHWfi+FOziYz3590J+bTbGc+PUisf3/kps5nlNa7YxE/3tEfrWzSeOvPOLd68RGfNntj9+URWP14x/CIx5tcRxEJyxinERnpz7qdvX@iPFslUgUTlKqDJhcV7kiEgJ?E?ACUTOOe54t/TnYKamybXiM49Zt/N/wA27+B62rT1lNSmcb6Wrn4c1w+D7T6K7be/q66N5mZxu2/m/nv91ro107zO+cPR9H6HZtebeu1NuPd9rH7XtPt5xPMTmJ6TCk15V7PpTo6WlpZ3Tp6dKbvi2VrGW+GUuacRM85j4mW1ba1wnApuZ7U7V8GEIyrhKOeTM5iMfMEot3GbYzjv+FW+ccdQiOU5Msom3Ef37yJvaIzjn6Ur7W5mGG63Phj8Xso3344+fs2MJ2ujcbmO5G4Rtb7k7nPvN5g2Oys8GWVLZhMqTLPHK+VcqbkblNydreJTllE8LxK0SrhfKVIlaF1UgJQISAgAShnOM4zy0no5r1yL1jMtExC1YnEZ645WwgmVUpBGUYQsAzjmZ8ljAJVUv3LTMR1UvaOmegmOqMqThE2rxGevRSbRjOeEtYhdXcrNuGVrxHenC8VazdnN2FrxzyxtqRjK0VbV0nVvN7gnW81Z1vNba19RL3dG+aRK82cfZb7tKJ87N5s4dW2LTHhZx2ri0x95M2RuUmRzzcw6azxC0SxrPENIdESzmG0LQyhpDaJZStAQZXUSACBKADE.RgAS?gSgEShMoQspaImOeGd4z39Wlv91L9wvXuYTWIx5f7qTHnPXLSWdlm8M7Tw5rY8W15cl7LxDppCl7dee/LmvfjGXPftmh8f8Nv6XLftWlP2v4bOitJ8LPRp2e/w2/C6rXjxZW1fNx27TTxZTr1lrFJdVdCfB9f6Pvu0Inzs7ZeV6Kvu7NX67PRy+f7RP53UjwvZ4evXGrqR9+yZIQZc+WeHTXpDVjWeI+TSLT3Q66zDnmGrRhW/OMN4b1mJZWzC2DBA0USAl)?C?EJBKFU98wShZnbp55Uv3NmV46C1Z5YWZ2bTDK0JdFZc13Hd3Xq5r0a1l1aUvitWZyx5d2pp8sfVvRiYfT1vGIc/I22SjYnK26H1fof/la/XZ6rzfREY7NX67PSfLdp/xtX67fzPl+0/42r9dgQOdi6K9I+S9YhSvSPkvTE/Pzrl117mMpr7/63ZDjrjdGOmeHY30ek/Uw1e5MCR0Mg)?ABCU?AjAlAlVS8dGuFbQheJYTDKYbzVWapaQ5rVZTR1zRGxOWsXw+MvTll6t3XpOekqbJ8Jdu59BXV46uL1avq3bsnwlE0nwlO5pGr5vY9GV/wCHr9dnfLm9H1xoRx32dVvk+f7RH5zUn79nh6051dT67KCeVeXLKror0j5NaRmJj+plXpHyaUisxOZxzx7Tsp1j6WFl/t/tuuHFT34xzGa8u506PSfqYavd9IA2Z))?IEo?EisrIBWYVw0RhC2WZtaAnL5S9Jypsl9N+Sdn/R/xW/qPyXs/6OP4m3rXox26mOlnzOyTZL6f8m0P0cJ/JtH9HT8J63yPy+nw2ed2OsxpR87OjDurp0rGIrER4RVOyvwx+FxX0d8zOettzjtr5tNsdbPMmso2y9TZXwj8KdtfCGf5N5nr/Jw1icR8mlJ29c/L+7OvHknhtGjjvZzq57nJWPbj5usF612K2tkAXU))?EJAQJAQSkEqiwCosIFRYBUWEiBICEgI)?f/Z!