Hi
I have two drop down list in my Qv application.Values for them are given below
Start-Date : CreateDate,AnalyzedDate,ConfirmDate,ImplementDate,IntegrateDate,VerifyDate,AcceptanceDate,.......(13 dates)
End-Date : CreateDate,AnalyzedDate,ConfirmDate,ImplementDate,IntegrateDate,VerifyDate,AcceptanceDate,......(13 dates)
Use can select any value from drop down 1 and drop down 2. I wan to create a third varibale (MaxDate) which calculates something base on the following logic.
Suppose I select start date : CreatedDate and end date : IntegrateDate the my requirement is to put the max value of (AnalyzedDate,ConfirmDate,ImplementDate) in varibale MaxDate.
If I select start date :AnalyzedDate and end date : VerifyDate the MaxDate should contain the maximum of (ConfirmDate,ImplementDate,IntegrateDate).
Ideally user can select any value from start and end state list both and requirement is to calculate the maximum of dates existing between those two start and end dates.
Thank in advance.
Regards
Tribhuwan
