how can I adjust the date format of function "//"

[John de Groot]

In a table I have one column that only contains a date created by "//" .

If I want to sort the table rows on the date in that column, it will sort first by day, then month, then year as the format for "//" is dd-MM-yyyy (so 2 april 2018, 3 may 2019, 4 april 2018). 

In general settings I changed the format to yyy-mm-dd, but that has no effect on the date created by "//".

how can I adjust the date format of function "//" ?

(OR   How can I correctly sort the table rows on dates specified in a dedicated column ?)

[Max Foerster - K15t]

Hi John,

how the macro renders the date depends on the overall language settings of your instance, language setting in the user profile and your browser (in that order). It's not affected by the the Date Time Format you just changed. 

Best, Max