Options

Date Conversion

Amin_IrAmin_Ir Member Posts: 2 Newbie
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

  • Options
    Amin_IrAmin_Ir Member Posts: 2 Newbie
    Numerical to Date operator
  • Options
    Telcontar120Telcontar120 Moderator, RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 1,635 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.