topic how to create new column as a day count between two date columns in App Development

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

suhascool1 — Thu, 15 Feb 2024 04:53:38 GMT

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 — Thu, 15 Feb 2024 04:57:54 GMT

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

eg Closed_Date - Creation_Date and label as Count_Days

suhascool1 — Thu, 15 Feb 2024 05:26:50 GMT

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 — Thu, 15 Feb 2024 05:30:46 GMT

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 — Thu, 15 Feb 2024 05:44:05 GMT

Thank you Lisa