Selecting Particular date

[#1]

Hi All,

I have a table with MS_Date. Where each Milestone has some MS_Date.

In the attached QVW you can find the Table where the expressions are milestones.

I need to display MS_Date based on Milestone

Ex. If Milestone is EMD then respective date should be displayed in the next column.

      If Milestone is ADV then respective date should be displayed in the next column. and so on

Please help me what condition has to be written.

Regards,

Keerthi KS

[jonathandienst]

I am sorry - this does not explain much even after looking at your qvw. What do you mean by "Milestone is EMD"? How do you want to display MS_Date? What and where is the "next column"?

[#3]

EMD is one Milestone. I have Many milestones in the table. All the expressions in the table are Milestones

Each Milestone is one transaction with MS_Date.

In the table you can see EMD next to it i should have MS_Date. MS_Date  of EMD transaction.

Please let me know if its not clear.