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.