Create a column with time difference between two columns in Analysis Services 2005 -
10-13-2006
, 11:25 AM
I have a table with two columns in it
ExportDate: 2006-09-20 17:10:00Z
CreationDate:2006-09-12 13:21:00Z
I want to create a another column containing the time taken from
Creation to Export of a product
I created a named calculation called Averagetime and wrote the
following expression in
ExportDate-CreationDate
However I'm getting time correct but the difference in the date is
incorrect It shows the following result.
Averagetime: 1900-01-09 03:49:00Z
Can u please help
Thanks |