Do you mean you need a minimum date of three date fields?
If yes, you can try something like this.
Load * from data.qvd;
Load min(DateField1) as Min resident Data;
Load min(DateField2) as Min resident Data;
Load min(DateField3) as Min resident Data;
Load min(Min) as MinimumDate resident Min_Temp;
Drop table Min_Temp;
Now you will have a minimum date from all three date fields.
Not quite, I want the minimum date from three date fields for each record in the data base.
So record number 1 might have 3 dates, I need the Minimum,
record 2 might have 1 date, I need the minimum (which will be that date)
record 3 might have no dates so I will get a blank
record 4 might have 2 dates, I need the minimum
I can then evaluate for each record whether they managed to action it in time bearing in mind they have three different options and may take all three options, one or not done anything....