Generate in script unique numbers for date field with sort

[maxsheva]

Hi,

I need generate in script unique numbers for date field with sort by ascending.

Date

01/01/17

01/02/17

01/03/17

02/2017

02/15/17

I need

Num, Date

1, 01/01/17

2, 01/02/17

3, 01/03/17

4, 02/15/17

5, 02/2017

Thx.

[MK_QSL]

May be

AutoNumber(Date) as Num

[maxsheva]

I already tried it but sort is not ascending by date

[MK_QSL · Accepted solution]

You can try

Data:

Load Field1, Field2, Date From TableName;

Left Join (Date)
Load Date, AutoNumber(Date) as Num Resident Data Order By Date;