将Excel数值日期转换为RapidMiner哒te-Time attributes

sgenzer

This is just a quick handy tool that I have used countless times - it converts those very annoying five digit "numerical dates" in Excel to a standardized RapidMiner date-time attribute.

For example, the Excel numerical date "42887" converts to "June 1, 2017".

Here's the process if you want to look at it. It's also on the Community Repository for easy access as a building block.

   
                         CONVERT EXCEL NUMERICAL DATES       This building block converts an attribute containing Excel &quot;numerical dates&quot; into the RapidMiner DATE/TIME format. For example, 42887 converts to June 1, 2017.<br><br>**Name your attribute &quot;date&quot; in order to run this process out of the box. You can test it by connecting the &quot;Generate Data&quot; operator to the subprocess and the output to results**   

[Fun fact - those numerical dates in Excel are the number of days since January 1, 1900.]

Scott

davidb

does this take into consideration the lotus 1-2-3 leap year bug?
https://docs.microsoft.com/en-us/office/troubleshoot/excel/wrongly-assumes-1900-is-leap-year

sgenzer

hmm interesting question@davidb. No idea. There must be an easy way to check...