DateTime Format

Everyday,
I copy & paste tasks from base table to active table
and change start datetime (format : yyyy-mm-dd hh:mm:dd)

They displayed well,
but I want change them (double-clicked), they displayed
like this 43589 days 23 hrs.

How can I fix this problem.

Hi @11156,

Welcome to the Coda community,

It looks like the column is a “duration” type and should be switched to a " date time" type.

:bulb:
It’s always better to share a dummy copy of your doc to be able to analyze and even make the correction and explanation

Best regards,
JP

I defined my column type DateTime
and modified that column, result of (today() + time column).