display days

[soniasweety]

Hi all,

\

I am calculating the days     but am getting the wrong out output

[its_anandrjs]

It seems you need this on the Load script then try this way to load on the Load Script

Load *,

Interval( Date(Date#('7/19/2017','M/DD/YYYY'),'M/DD/YYYY') - Today() ,'D') as  [Open Days],

Interval( Date(Date#('7/19/2017','M/DD/YYYY'),'M/DD/YYYY') - Today() ,'D') as [Last Updated Days]

Replace this lines for your fields and let me know what result you get.

Or May be this or change the field name please in your load script

Interval( Date(Date#('7/19/2017','M/DD/YYYY'),'M/DD/YYYY') - Today() ,'DD') as  [Open Days],

Interval( Date(Date#('7/19/2017','M/DD/YYYY'),'M/DD/YYYY') - Today() ,'DD') as [Last Updated Days]

[soniasweety]

thanks anand,I will check and update you