How to assign value(ID) to CalendarDate?

[#1]

hi everybody,

how I can assign a value(Id) to a CalendarDate, like:

I have:

storeid | calendardate | Id

123     | 22.01.2012    | 2

123     | 23.01.2012    | 1

123     | 26.01.2012    | 5

123     | 01.02.2012    | 3

123     | 07.02.2012    | 4

I need:

storeid | calendardate | Id

123     | 22.01.2012    | 1

123     | 23.01.2012    | 2

123     | 26.01.2012    | 3

123     | 01.02.2012    | 4

123     | 07.02.2012    | 5

Thx in advance.

[rajeshvaswani77]

You can use RecNo() function to generate numbers from 1 onwards.

[#3]

RecNo() function will doesn't work because I have group my Id to the StoreID:

My Table look like this::

storeid | calendardate | Id

123     | 22.01.2012    | 2

123     | 23.01.2012    | 1

123     | 26.01.2012    | 5

123     | 01.02.2012    | 3

123     | 07.02.2012    | 4

456     | 28.01.2012    | 2

456     | 30.01.2012    | 1

789     | 24.01.2012    | 2

789     | 28.02.2012    | 3

789     | 01.03.2012    | 1

I want for Id the same order as calendardate.

[rajeshvaswani77]

Convert the date in to the real date. sort by the date then and use recno() to generate your row.

[Anonymous]

mmmm load the calendardate 2 times like this

load

calendardate,

calendardate as ID,

....

and when use ID change the format number for Integer.

Maybe help you

[#6]

the calendardate is already in the right order, I want the same order for Id.

[rwunderlich]

autonumber(calendardate, storeid) as Id

-Rob

[CELAMBARASAN]

Hi,

     Have you tried with the RowNo() function?

Celambarasan