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.
Please post screenshots of the complete column configurations that do not work as expected.
this might be my problem
Hi Steve, thanks for your prompt replied.
I was planning to make the screen shot, but weird thing is, it working fine now.
I wonder why I tried yesterday, it always returned blank.
Just want to make sure: is it my column name canโt be like โDateTimeโ? Due to DateTime is a reserved word?
I would expect a column named โDateTimeโ or โDate Timeโ to work fine in expressionsโso long as it occurs between square brackets when you want the column value (e.g., [DateTime]
) , or in quotes when you want just the column name (e.g., 'DateTime"
).
Hello @Steve can you helpme please.
I have the same issue, I have a type column DateTime named โSeguimientoโ, and a virtual colum named โFecha Campo Seguimientoโ, I want get only the date from the colum โSeguimientoโ.
I use the formul Date([Seguimiento]), but the result is blank
The colum:
The value captured:
The virtual colum:
Please post a screenshot demonstrating this.
Hi Steve, I had to choose another option to get the value and I set the column as only Date.
Thank you anyway
User | Count |
---|---|
61 | |
25 | |
14 | |
11 | |
6 |