Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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];
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];