Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have KPi object
if(today()>duedate,1,0) as DueDateFlag, ----- this expression in script used.
KPI expression:
ount({<DueDateFlag={1},iD-={'3','4'}>}Number)
here logic is greater than due date from today values should count but I have 8 null values it is not counting so how to include that?
end date is timestamp
12/29/2017 2:10:30AM
end date? what do we need end date for?
what about the due date? is that a timestamp also?
sorry sunny due date only its timestamp only
Then may be do this
If(Now() > Alt(duedate, Today()-1), 1, 0) as DueDateFlag,
or your DB check should be by truncating the duedate to just date based on your requirement
DueDate='2018-04-27 17:31:27.733'
May be try
=If(IsNull(DueDate) OR(Today()>Date(Floor(Timestamp#(DueDate,'YYYY-MM-DD hh:mm:ss.fff')))),1,0)
this gave correct result
If(Now() >due_date, 1, 0) as DueDateFlag,