Table with dates

[reijk317]

I need some help.

I have a table with a id, startdate and enddate.

I like to make a table with the id and the dates like my example.

How do ik do this.

My next question is, how can i display this in a calendar like this?

[Anil_Babu_Samineni]

1) Like this

Load ID, Startdate + Iterno()-1 as Date

While Startdate + Iterno()-1 <= Enddate;

Load ID, Startdate, Enddate From Table;

2) You need to develop this using Pivot table.

[woshua5550]

plz check the attachment,hope it can help you