VC or Column

[Qiro]

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?

[1minManager · Accepted solution]

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.

[Qiro]

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