system
October 22, 2010, 2:44pm
#1
I am building a report that needs to show the time that a work item was sent to a particular work queue. The object is a dttime field, and I formatted it to show time only:
=FormatDate(, “HH:mm:ss”)
The problem is that there is an inconsistency between the source data and the universe (I think due to daylight savings issues) where the source system which is correct might say 6pm, but the data in BusObj says 5pm. So I am looking to add 1 hour to all my times, but am having trouble accomplishing this.
Any help would be greatly appreciated.
JPritch (BOB member since 2004-12-29)
system
October 22, 2010, 2:57pm
#2
Hi,
It’s not a nice and simple formula but it should work:
Hi
I just wanted to add an hour with my existing timestamp, your input is more appreciated. I wanted to do this only on the Report and not on the universe.
Say the time in the column 14-08-2009 14:30:00, i wanted to display it as 14-08-2009 15:30:00
Regards
Siva.M
looksmee (BOB member since 2006-02-08)
Marek Chladny (BOB member since 2003-11-27)
system
October 22, 2010, 5:32pm
#3
Marek,
Doesn’t have to be pretty as long as it works, and works it does! Thank you sir!
JPritch (BOB member since 2004-12-29)
system
October 23, 2010, 7:28am
#4
I am glad to hear that it works for you and you found it useful. 8)
Marek Chladny (BOB member since 2003-11-27)
system
October 25, 2010, 12:03pm
#5
A Simple Formula. Hope it helps.
=FormatDate(CurrentDate() ,“dd-mm-yyyy”)+" “+(FormatDate(CurrentDate() ,“HH”)+1)+FormatDate(CurrentDate() ,”:mm:ss")
Regards,
Rangu
rangu (BOB member since 2010-05-28)
system
October 25, 2010, 12:07pm
#6
Yes, a simple formula but my guess is that it would not work when adding 1 hour changes also the date part of the datetime.
Marek Chladny (BOB member since 2003-11-27)
system
October 25, 2010, 12:25pm
#7
Can you please illustrate with an example?..
rangu (BOB member since 2010-05-28)
system
October 25, 2010, 12:34pm
#8
When CurrentDate() will be for instance 25-Oct-2010 23:30:12
Marek Chladny (BOB member since 2003-11-27)
system
October 25, 2010, 12:39pm
#9
wat is the expected result here?..
rangu (BOB member since 2010-05-28)
system
October 25, 2010, 1:23pm
#10
Maybe 26-Oct-2010 00:30:12?
Marek Chladny (BOB member since 2003-11-27)
system
October 27, 2010, 5:50am
#11
U are right… It will not work… I tested it… Will try to find a simple formula…
rangu (BOB member since 2010-05-28)