Date Conversion

Amin_IrAmin_Ir Member Posts: 2 image Learner I
in Help
Hi All,
How to Convert The Numeric Attribute <DTYYYYMMDD> to Normal Date? (Image 1)
Because When i use Numerical to Date Attribute ,All Date convert and back to 1970!!






Tagged:

Answers

  • Amin_IrAmin_Ir Member Posts: 2 image Learner I
    Numerical to Date operator
  • Telcontar120Telcontar120 RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 1,635 image Unicorn
    You'll want to convert your date to a polynominal type first instead of a numerical (since numericals will be converted based on the number of milliseconds from midnight on Jan 1, 1970, which is why you have the dates that you do). In your example, after converting to a nominal (use Numerical to Nominal), the correct pattern for the Nominal to Date operator would be  yyyyMMdd
    Brian T.
    Lindon Ventures 
    Data Science Consulting from Certified RapidMiner Experts
Sign In or Register to comment.