Calculate Age (Days) Between 2 Dates

[jmonroe918]

I have two dates: CreateDate and CloseDate and would like to calculate the age of the record that contains these two dates. My questions are:

1. What is the expression for calculating the date difference to determine the age of each record?
2. How do I incorporate that into the load code?

Thanks.

Jeff

[Anonymous]

Hi Jeffrey,

Use below load script:

Let vStartDate = MM/DD/YYYY;

Let vEndDate = MM/DD/YYYY;

Data:

LOAD

StartDate,

EndDate,

($(DateDiff(StartDate>$ (vStartDate) , EndDate <=$(vEndDate))) AS AGE

FROM DataSource;

[Sokkorn]

Hi Jeff,

May we can try this:

[TableName]:

Load *,

     If(DayOpen<30,'<30',If(DayOpen<61,'31-60',If(DayOpen<121,'91-121',If(DayOpen>120,'>120')))) as [OpenBucket];

Load

     ID,

     Status,

     CreateDate,

     CloseDate,

     Floor(Today()-CreateDate)     as DayOpen;

Select ID, Status, CreateDate, CloseDate From TableName;

Regards,

Sokkorn