Hi Team
I did not find my luck by searching in the forum.
Would anybody please guide me to get this solved in BOXI 3.1 SP 2 WebI report level, not in universe level.
DB Sybase 15
Task Started Date at: Dec 4, 2010 03:30:22
Task End Date at: Dec 4, 2010 13:10:10
I what milliseconds difference between Task Stared Date and Task End Date.
How to get this achieved.
Thanks for your prompt replay . When I apply “DaysBetween” function and getting “0” (even after changing the format of the cell into decimals).
What is the function that I need to calculate?
Please do the needful
I tried with given solution by you, but no luck .
Do please correct me where I am going wrong. Please find the attached screen shots of both DB and WebI
Check whether the dates that you are pulling in the report returns the format with Milli secs or only the date format.
If only the dates are returned even though you apply any logic at the report level to calculate the milli seconds will not work
If the dates are returned as expected then apply the logic to calculate the difference in mill seconds by multiplying with respective numbers.
Otherwise I would prefer to change the date to character in universe to in the date time format and then start using that in the report to calculate the difference in Milli Seconds format