Exceeded days required

[Sra1bandi]

Hi Team,

Need the exceeded days 

Inline

[

Id    End date

1       03-10-2022

2        02-10-2022

3       04-10-2022

4       06-10-2022]

for suppose today is i.e, 03-10-2022

i need 

if End date is < Today i need to show as 0

if End date is > Today i need to show as  

for suppose for id 3 = 1 Day

id 4 = 2 daays

thanks,

sra1.

[JHuis · Accepted solution]

Dear Sral,

Load
*,
if(Enddate<Today(),0,If(Enddate>Today(),Enddate-Today(),0)) as DaysDifference;

LOAD * Inline

[

Id , Enddate

1 , 03-10-2022

2 , 02-10-2022

3 , 04-10-2022

4 , 06-10-2022];