AnsweredAssumed Answered

Date Calculation issue in webi

Question asked by madhavi.b on Jan 22, 2016
Latest reply on Feb 1, 2016 by JussiValkonen

HI

 

My requirement is to calculate the difference between two dates.

Default date format for OOTB column - MM/dd/yyyy hh:mm:ss but for customized column, date format is getting in mm/dd/yy.

For example:

OOTB column - 01/11/2016 09:25:33

zcolumn - 01/20/16

 

Here I have changed the zcolumn o/p in OOTB date format using the formula "FormatDate([Zaccep Time]; "MM/dd/yyyy hh:mm:ss" )". Now the issue is, when I tried to calculate the diff.b/w OOTB column and zcolumn, the data is not getting correctly. PLease help.

For calculating the difference, the formula I am using is PdmSeconds(PdmDownTime('Gold','Mon - Fri { 8:00 am - 5:00 pm }', cr.open_date,cr.zaccep_time))

 

Thanks

Madhavi

Outcomes