I need generate in script unique numbers for date field with sort by ascending.
AutoNumber(Date) as Num
I already tried it but sort is not ascending by date
You can try
Load Field1, Field2, Date From TableName;
Left Join (Date)Load Date, AutoNumber(Date) as Num Resident Data Order By Date;
Retrieving data ...