Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
interval(startdate - enddate,'mm')
Adam,
I hope you meant the below one.
Interval(enddate- startdate,'mm')
haha yes, my mistake!
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
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..
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
Hi,
Have a look at the attached file. It's working fine.
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')