I have two date fields date1, date2 and stores in column name result . I need the difference of the two dates to be calculated and store no of days in the result.
Problem here is with two cases:
- case 1: if date1 is lesser than date2 then Null error.
- case 2: if date2 is lesser than date1 then Null error.
Condition I placed is:
I am pretty confused in figuring out the trick. Help me in getting this.