Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI ,
i have opendate of the incident. i want to see the time differnce of that incident
The calculation which user has given is currrentdate-opendate<60 minutes. How to implement in script level( i need the output as in minutes)
i have tried as interval(Timestamp(now)-Tiestamp(Opendate))<60. i am not getting correct output.please help me
try like below
=interval( (TIMESTAMP2 - TIMESTAMP1)<60, 'hh:mm')
or may be
Timestamp((Timestamp#(EndDateTime) - Timestamp#(StartDateTime))<60, 'hh:mm:ss')
Try
interval(Timestamp(now)-Timestamp(Opendate),'mm')
Regards,
Kaushik Solanki
in the script i have wriiten as
Interval(Timestamp(now())- Timestamp(INOPEN_DATE)<60,'HH;MM') as TimeTaken;
the output is not showing as per above screenshot
interval(Timestamp(now())- Timestamp(INOPEN_DATE)<60,'hh;mm') as TimeTaken;
or
interval(Timestamp(now())- Timestamp(INOPEN_DATE),'hh;mm') as TimeTaken;
Hi plss send some sample data.
When u take the difference its better to use NUm() on dates n then compare..
Sachin
it is not coming chanty
try this
.
floor((TimeEnd-TimeStart)*24*60*60)
May be this
Interval (Timestamp#(TimeEnd,'DD/MM/YYYY hh:mm:ss') - Timestamp#(INOPEN_DATE,'DD/MM/YYYY hh:mm:ss TT'), 'hh:mm:ss TT')