Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
You can create variable. Which date you want to date Min date
LET Var = Min(DateField);