Solved: VC or Column - Page 2

Qiro · 06-29-2023 01:25 AM

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

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.

View solution in original post