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

FormatDateTime(DateTimeToDate(CarrierContractTable.List.Current.CarrierContract.ValidFrom),"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


Solution

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:

Year(Booking.CheckInDate)+"/"+Month(Booking.CheckInDate)+"/"+Day(Booking.CheckInDate)

Cheers!


Solution