Database design with multiple date fields

[#1]

Hi,

In Current scenario we have a table with around 150 Columns and minimum of 10 date fields. And this table is multi tenant since multiple customers data is stored.All the date fields are stored in different columns not as single column. I need to show the charts based on Yearly,Weekly,Monthly ,Daily,Hourly based on every date fields.

Since data size is huge i cant use the cross table to convert the rows in to columns to ensure that all the date columns in to single column.

How to proceed on this?????

[vgutkovsky]

What do you mean that the chart has to be based on every date field? Are all the dates identical? Do you want to have a cycle group of the dates?

[#3]

Hi Vlad,

I will be having one chart by Recived date, one chart by modified date,one chart by Assigned date. In this scenario i should have only one date selection list box based on which all the charts should get changed accordingly....

[sunil2288]

HI XXX,

You should go with creating a single calender. And you need to give the link (Reference) to all the date fileds you do have in the application..

So that refering to a single date selection whole of your application get referred each time.

Regards

Sunil

[vgutkovsky]

I agree with Sunil. Otherwise you would have to create a date island and refer to that in every expression--this would slow down performance considerably.