Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Alt date | Targ date | No |
1-Aug-18 | 2-Aug-18 | 12 |
3_aug-2018 | 123 | |
4-Aug-18 | 12345 | |
1234567 | ||
6-Aug-18 | 7-Aug-18 | 123123 |
8-Aug-18 | 1212 | |
Now the Requirement is
Introduce new field call due date where the logic will be like below | |||
a) If “Alt date” field is blank, then it captures the “Targ date” in the “due date” field. | |||
b) If “Alt date” field has an entry, then it captures the “Alt date” in the “Due date” field. | |||
c) If “Alt date” field and “Targ date” field are both populated, then it captures “Alt date” in the “Due date” field. | |||
can anyone please check and help
hi anyone please check and help
load
altdate,
targdate,
if( altdate <> null() and targdate <> null(),altdate,
if( altdate = null() ,targdate,
if( altdate <> null() ,altdate) ))as duedate,
no
Did the poster's comment help you resolve things? If so, please be sure to give them credit by clicking the Accept as Solution button on their post. If not, please leave an update on where things stand.
Regards,
Brett