how to create new column as a day count between two date columns

[suhascool1]

Hi,

How to Create a new column as Count_Days between two date columns.

eg : 

Creation_Date	Closed_Date	Count_Days
02-15-2024	02-10-2024	5

Thanks

Suhas 

[Lisa_P · Accepted solution]

The Simplest way is to use the column name or Field name

eg Closed_Date - Creation_Date and label as Count_Days

[suhascool1]

Creation_Date column in one Table1 and Closed_Date Column in the another Table2.

so how to Create Count_Days Column in the script.

[Lisa_P · Accepted solution]

If they are being loaded in the same table add another column in the load script like:

Load   .....,
    Creation_Date,
    Closed_Date,
    Closed_Date - Creation_Date as Count_Days,
    ...

[suhascool1]

Thank you Lisa