Compare two dates

[#1]

Hi

Promised Date	Actual Date
01/01/2015	03/01/2015
23/01/2015	20/01/2015
23/01/2015	23/01/2015

Hi I want to make a new field say XYZ,

I want XYZ to be 1 id Actual Date is equal or less than promised date.

XYZ should be 0 otherwise.

How can I achieve this?

Please help.

Thanks

Arjun Jain

[PrashantSangle]

Hi,

Both field in same table then

write in script

if(ActualDate<=PromisedDate,1,0) as Flag

Regards

[robert_mika]

if(Actual Date<= Promised Day,1,0) as XYZ

[pokassov]

Hi!

t1

Load

     [Promised Date],

     [Actual Date],

     if( [Actual Date]<=[Promised Date],1,0)     as XYZ

Resident

     YourTable;

drop Table YourTable;

rename table T1 to YourTable;