Business Objects 6.5 Difficulties writing code

[ashcon]

I have recently started using BO as part of my responsibilities at work.

I am trying to create a report and assign an overall date based on 2 variables( TTG and TAS). The IF/Where statements I have written seem to be missing something as i keep getting an error.

The results should be such that:

-If the TAS is "Cancelled", do not assign that entry's v_min start date as overall date.
-If the TTG is "Respond Billing" do not assign that entry's v_min start date as the overall date.
Otherwise assign the minimum/oldest date value of the remaining entries as the overall date.

I have asked this question on BOB and there doesn't seem to be anyone who can figure it out, I am hoping someone out there knows how I can go about this. Here is a sample of the data:

Entry TAS TTG v_Min Start Date
A , Cancelled , Incomplete, 18/10/2013
B , Inactive , Incomplete , 29/12/2014
C , Inactive , Installation , 25/02/2014
D , Inactive , Installation , 17/10/2014
E , Cancelled , Installation , 19/02/2015
F , Inactive , Investigation , 11/12/2013
G , Inactive , Investigation , 09/01/2015
H , Inactive , Investigation , 05/02/2015
I , Inactive , Respond Billing , 08/12/2013

The Overall Date(Result)for this data set is 11/12/2013.

Any help is appreciated.

 

[SkipVought]

Select min([v_min Start Date])

Where [TAS] Not "Cancelled"
And [TTG] Not "Respond Billing

 

[ashcon]

Thank you SkipVought....finally a helpful person, I will try the solution and feedback.