Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Do we have some step to convert AD date into yyyy-MM-dd?

  1. #1
    Join Date
    Jun 2016
    Posts
    181

    Default Do we have some step to convert AD date into yyyy-MM-dd?

    I have dates as numbers (for instance 42390). I see this post can be solution: https://forums.pentaho.com/threads/1...dable-formats/

    But do we have some step to use to convert it instead of Java code?

    Regards

  2. #2
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    42390 isn't an AD date.
    It's an Excel date.
    You can do it with calculator, by adding the number of days to Dec 30, 1899.... With issues. In Excel, day 60 is Feb 29, 1900 - a date that doesn't exist. Day # 1 is Jan 1, 1900. So any values that you're converting that are between 1 and 60 need to be adjusted by one more.

    There hasn't been a step developed because no one has yet expressed a need for it. When it's being imported from Excel, it gets converted from a number to a date...

  3. #3
    Join Date
    Jun 2016
    Posts
    181

    Default

    To my surprise it works ;-)
    Thank you!
    I have such 'dates' in text file so automatic conversion does not take place.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.