How to get Maximum date in Load Script

[SatyaPaleti]

Hi Friends,

Need a small help

I am having a field called Receipt date

I want to calculate Minimum Receipt Date only in script

I am using

Load

Min(Receipt Date) as Minimum Date

from xyz.qvd

But it is showing error

could any one of you help how to write this inn script level

Thank you,

Satya

[ramasaisaksoft]

Hi Satya,

Can u please check this in Resident load

T1:

Load

Receipt Date

from xyz.qvd;

Load

min([Receipt Date]) as d1

Resident  T1;