For my application i changed my table format from DD/MM/YYYY to YYYY/MM/DD.


My filter to sort by effective date is currently working but in the DD/MM/YYYY format.

is it possible to make this YYYY/MM/DD?

Video of what i'm trying to achieve


Hello Jan,

Answering to your questions, yes. You can do the sort like you're trying to do. However, I would recommend you to do that format in a new column of an advanced query. Like that you can have both formats and handle them as you want!

You can do it in an aggregate like this, but I would go with the advanced query: