Date Formatting

[RUSA762]

The formulas always return the column as the same dtype as the argument. So for example, if we have the date 2021-01-01 00:00:00 the formula =LEFT(date, 10) returns the column as a date, and adds the timestamp of 00:00:00 back. In this way we get our original value returned. This might make sense for certain operations, but not all of them.

Offering the selection of more datetime formats, such as mm/dd/yyyy, would be helpful.