Date generation

[rahulsud007]

ID	jan	rowno()	Year
AO	0	1	2015
AO	1	2	2015
AO	0	3	2015
AO	1	4	2015
AO	1	5	2015

Dear Experts, this is the format which I currently have

and I need the output by replacing Rowno with date. Such as

date

1-jan-2015

2-jan-2015

3-jan-2015

4-jan-2015

5-jan-2015. Can you please help me in this?

[anbu1984]

Temp:

Load * Inline [

ID,jan,rowno,Year

AO,0,4022,2015

AO,1,4023,2015

AO,0,4033,2015

AO,1,4044,2015

AO,1,4065,2015 ];

Load *,Date#(RowNo()&'-'&'Jan-'&Year,'DD-MMM-YYYY') As Dt Resident Temp Order by Year,rowno;

Drop Table Temp;