mindate from script

[nareshthavidishetty]

Hi How to get the min date in script level.

Highlighted is the business logic to get date.

T01:

LOAD A7BANB as order_number,

    A7AIDT as order_date,

   A7AIDT,   

  if(match(A7AACD,'112','073'),'3/19/2017',min(date(date(date#(A7AIDT+19000000, 'YYYYMMDD'),'M/D/YYYY')))) as activation_date,   

    A7AACD  ;

SQL SELECT A7BANB,

    A7AIDT,

    A7AAVN,

    A7AACD

    FROM AS400D60.DISPDBF.DSA7CPL0;

[Anil_Babu_Samineni]

You can create variable. Which date you want to date Min date

LET Var = Min(DateField);