need help

[mshailaja]

i have start date and en date as below, i want to show the difference between those two dates in minutes in script level, below is the

sample data. can anyone help pleasee

i want to show the diffrenece in minutes.

[adamdavi3s]

interval(startdate - enddate,'mm')

[tamilarasu]

Adam,

I hope you meant the below one.

Interval(enddate- startdate,'mm')

[adamdavi3s]

haha yes, my mistake!

[tamilarasu]

[mshailaja]

I have tickets which are in opendate, i want to do analysis about the tickets which are in open state lik below screen shot

and i want the report like this

Anyone please help

[mshailaja]

I am working in the server,if i am keeping in the interval function , i a m getting like this

, secondsit is directly coming from the database. i want to show in minutes.please help..

[Anonymous]

hi,

Maybe this:

num#(Interval(timestamp#(timestamp(enddate,'YYYY-MM-DD hh:mm:ss'),'YYYY-MM-DD hh:mm:ss')

                    -timestamp#(timestamp(startdate,'YYYY-MM-DD hh:mm:ss'),'YYYY-MM-DD hh:mm:ss')

                   ,'m')) as CompletedTimeMinutes

[tamilarasu]

Hi,

Have a look at the attached file. It's working fine.

[hemachandran]

Hi.

can u try this...

=Interval(Date(date#(startdate,'DD/MM/YYYY hh:mm:ss TT'),'MM')-Date(date#(Enddate,'DD/MM/YYYY hh:mm:ss TT'),'MM'),'MM')