Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
The Simplest way is to use the column name or Field name
eg Closed_Date - Creation_Date and label as Count_Days
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,
...
The Simplest way is to use the column name or Field name
eg Closed_Date - Creation_Date and label as Count_Days
Creation_Date column in one Table1 and Closed_Date Column in the another Table2.
so how to Create Count_Days Column in the script.
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,
...
Thank you Lisa