VC or Column

AppSheet AppSheet Q&A
,
1

Hi guys,

If you have a Datetime value in a cell, but want to extract the DATE() value, from a computational point of view, does it make more sense to use a VC, or have a separate Date column?

Also, is there a way to display just the Date value of a Datetime column without using a VC?

2

If you have a Datetime value in a cell, but want to extract the DATE() value, from a computational point of view, does it make more sense to use a VC, or have a separate Date column - No you always avoid using virtual columns if you can. Normally quicker if you must to have a second column to use Date() as its app formula

Also, is there a way to display just the Date value of a Datetime column without using a VC? - As above, otherwise no.

1 Like
3

That’s precisely what I’ve done, to be honest. Thank you.

1 Like