In BusinessObjects v.4.1.5 there doesnt appear to be any other internal functions other than the ‘Days Between’ function. Is there a way that I could return a ‘Minutes Between’ or ‘Seconds Between’ between two dates in BusinessObjects v.5.0.2??
Thank you.
Listserv Archives (BOB member since 2002-06-25)
Lucia
There is no straight-up function that you can apply in BusObj at this time. However, you could try a numeric algorithm. Depending on the format of your data and what exactly you’re attempting to achieve a simple subtraction and division by 60 will probably do the trick.
Let me know if you need a hand.
Ang.
Listserv Archives (BOB member since 2002-06-25)
Thank you, Angela for your reply. I found in the BusinessObjects Tech support site Resolution Entry 2688 to mulitply by 24 to get hours, 1440 for minute and 86400 for seconds. I haven’t tried it yet. But I assume you convert everything to seconds, take the difference, then convert it back to days, hours, minutes and seconds. Will try it out and let you know. Thanks again.
Lucia
From: Angela E. Bishop [SMTP:mrsbish%OZEMAIL.COM.AU@internet.kraft.com] Sent: Monday, April 03, 2000 6:02 PM
Lucia
There is no straight-up function that you can apply in BusObj at this time.
However, you could try a numeric algorithm. Depending on the format of your
data and what exactly you’re attempting to achieve a simple subtraction and
division by 60 will probably do the trick.
Let me know if you need a hand.
Ang.
Angela E. Bishop
Senior Consultant
BanDIT Consulting Pty Ltd
Pls report bounces in response to postings to BUSOB-L-Request@listserv.aol.com
Web archives (24 hrs. a day now!): listserv.aol.com/archives/busob-l.html
OR search: Mail to listserv@listserv.aol.com, ‘search a_phrase in BUSOB-L’
Unsubscribe: Mail to listserv@listserv.aol.com, ‘unsubscribe BUSOB-L’
Listserv Archives (BOB member since 2002-06-25)