Extra date format

For European dates the following format is available: 20/01/2021. When we import (cut and paste) from excel, it seems like it is almost impossible to import dates without a bunch of work arounds (it can be done, but it is complicated).
Could we get an extra column date format that looks like this: 20-01-2021. It would make life a lot easier.

And further to this: there is an (undocumented) canvas function FormatDateTime(). Could it please be adapted with a few more options. For the date part: same as above (20-01-2021) and for the time part an extra option to not show the time at all.

2 Likes