Difference between Dates in Load Script

[Sai33]

Hello All,

I have my calender dates in the following format. I would like to generate a new column with the difference nbetween the two Date fields.

CD	PD
43759	43594
43759	43616
43759	43669

I would like the diff as a new field. My result table should look similar to the onw below.

CD	PD	Age
43759	43594	>150
43759	43616	100-150
43759	43669	50-100

My load Script is as follows:

LOAD

[F2 Num],
[Current Date],
If([F2 Num]-[Current Date]<=2,'<=2 Days',
If([F2 Num]-[Current Date]>=3 and [F2 Num]-[Current Date]<=10, '3-10 Days',
If([F2 Num]-[Current Date]>=11 and [F2 Num]-[Current Date]<=30, '11-30 Days',
If([F2 Num]-[Current Date]>=30 and [F2 Num]-[Current Date]<=89, '30-89 Days',
If([F2 Num]-[Current Date]>=90 and [F2 Num]-[Current Date]<180, '90-180 Days',
If([F2 Num]-[Current Date]>=180, '>180 Days'

)))))) as Age

Thanks!

But, it doesn't work as expected.

[Sai33 · Accepted solution]

Solved via Nested IF.