Double column to Date column

Hi,

I have a table with a double column for time - 20,200,101 (which is 1 Jan 2020)
Capture1
I want to conver it to date via Number to String and String to Date&Time. However, when Number to String convers the double to “2.0200101E7”
Capture2
Is there another way I can conver a double column to a date column?
Thank you.

Connor

@wuyeehow - @RolandBurger suggested this approach:

You can solve this by using a Round Double node instead of Number to String. Just set the precision to 0 and choose Standard String as output format.

3 Likes

That works! Thank you.

2 Likes