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

[Gosforth]

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

[gutlez]

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...

[Gosforth]

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