Dates (Scripting)

[hkg_qlik]

Hi,

I have four date fields part of the same table:

1. A - Start Date

2. A - Stop Date

3. B - Start Date

4. B - Stop Date

Now while loading this table I want to convert four date fields into two by picking Max dates from ( A- Start Date and B - Start Date) = New Start Date and similarly

max (A-Stop Date and B- Stop Date) = New Stop DAte

Thanks,

H