mindate from script

nareshthavidishetty — Wed, 25 Nov 2020 16:16:04 GMT

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;

Re: mindate from script

Anil_Babu_Samineni — Fri, 17 Mar 2017 16:19:27 GMT

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

LET Var = Min(DateField);