Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Both field in same table then
write in script
if(ActualDate<=PromisedDate,1,0) as Flag
Regards
if(Actual Date<= Promised Day,1,0) as XYZ
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;