Hitachi Vantara Pentaho Community Forums
Results 1 to 1 of 1

Thread: Simple Excel input file - wrong preview

  1. #1
    Join Date
    Jun 2010
    Posts
    114

    Default Simple Excel input file - wrong preview

    I have an excel file in which one of the column is a date.
    When I click the preview on the Excel input file...
    Instead of showing the date 10/1/2009 it was showing 12/31/1969
    Even, I have tried writing into a file, but all the dates are shown as 12/31/1969 for some reason.
    I did mention the format MM/dd/yyyy in the fields tab for the excel input file.

    Did anyone come across such an problem or know why it is happening?
    Last edited by omm; 08-27-2010 at 09:38 AM. Reason: Adding more details
    Thanks,
    Om
    ----------------------
    Spoon version -4.4.0

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.