Multiple Dates

[hopkinsc]

Hi everyone,

I have multiple dates in my application. I am trying to think of the best way to handle them so users can choose a date from either of the date fields easily.

I have thought of doing the following but unsure if and how it can be done..

1. Create a date island

2. The user selects a date from the new date island and then selects which date they want to use (Start, Completed, Raised)

3. This then selects the island date selected in the required date field.

I have attached a sample.

Any help or other suggestions will be appreciated

Many thanks

[alexandros17]

It's a good idea, but each type of date have a specific meaning so I would prefer three fields in multi selection box each one on a date.

[hopkinsc]

hi Alexandros,

Thanks for your reply

although its not just 3 fields (i have only put 3 in my sample)

there will be:

Specific Date

Month

Year

Quarter

for each Date selection (12 fields in total) which is why i thought that having a multi box would be messy and not very user friendly.

[er_mohit]

Hii For this

You have to make master calender then using floor function with your different date you can link with this calender.

make sure that the date format for all datefield is same .Hope it helps You

you could join also for doing that but it quite complicated table because your all Fact tables are attached in one table

Hope it helps you

[hopkinsc]

Hi, thanks for your reply. I wanted to try and get it working with the example i have posted,

Does anyone know if it's possible

[hopkinsc]

Does anyone have any ideas ?