need help

[mshailaja]

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

[Chanty4u]

try like below

=interval( (TIMESTAMP2 - TIMESTAMP1)<60, 'hh:mm')

[Chanty4u]

or may be

Timestamp((Timestamp#(EndDateTime) - Timestamp#(StartDateTime))<60, 'hh:mm:ss')

[kaushiknsolanki]

Try

interval(Timestamp(now)-Timestamp(Opendate),'mm')

Regards,

Kaushik Solanki

[mshailaja]

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

[Chanty4u]

interval(Timestamp(now())- Timestamp(INOPEN_DATE)<60,'hh;mm') as TimeTaken;

or

interval(Timestamp(now())- Timestamp(INOPEN_DATE),'hh;mm') as TimeTaken;

[sdmech81]

Hi plss send some sample data.

When u take the difference its better to use NUm() on dates n then compare..

Sachin

[mshailaja]

it is not coming chanty

[Chanty4u]

try this

.

floor((TimeEnd-TimeStart)*24*60*60)

[Chanty4u]

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')