Hi, I need to create a formula in a calculated field. The formula has to calculate the difference between two dates (creation date and now) and give me the result in hours, because in the report I have to show the time in hours from the creation date until now.
Until now I tryed those formulas:
{hoursUntil({P0})}
{datediff({P!}; {P0}; hours)}
{subtract({P1},{P0})}
{subtract(hoursUntil({P1}),hoursUntil({P0}))}
{subtract(number(subStr(toString({P1}),5,6)),number(subStr(toString({P0}),5,6)))}
where P1 is now and P0 is the creation date.