Sort Date without using key

Hi All,

is it possible to sort date without usign key?

Use Date Table

Hi,

for a standard navision table such as Item, Customer or Sales Lines - there is no option to sort without using a special key.

It mainly depends on the reason why you ask for this option.

For reports you could use - as suggested by Mohana - the “Date” table as data item followed by the table (and indented) you want to sort by date.
Even though this report will become terribly slow when having several tenthousands of records as the server has to process a full table scan rather than an indexed scan on the indented table.

Conclusion:

Better use a key which includes the date field.