After migrating from Pentaho version 5 to Pentaho 9.3, we were facing date conversion issues in the Excel extracts. Date values are automatically getting converted into timestamp value while writing into an Excel file. Let me know if there is any workaround to avoid this issue.
Thanks in Advance
what is source of data, table input step or something else? This is too less information.
If source is table in DB, problem is that database has set support for timestamp data type (it's default settings and is added in PDI v5.2 ). Check settings and try disable this settings.
A proud part of Hitachi Vantara
© Hitachi Vantara Corporation. All Rights Reserved.