Exceeded days required

Sra1bandi — Mon, 03 Oct 2022 13:43:18 GMT

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.

Re: Exceeded days required

JHuis — Mon, 03 Oct 2022 14:34:32 GMT

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];