Converting DateTime Column to Date only and Time Only

[aijac1314]

Recently I found an error in appsheet, I am trying to create a virtual column which converting an existing column to DATE, below as the setting:

Original column is DateTime type, with initial value of NOW(),

Then I create two additional columns, which Date([Date Time]) and Time([Date Time]), it returning blank.

Now what i temporary fix this problem with: DAte(Left([Date Time],10)) and Time(Right([Date Time],11))

I wonder what happened.