My excel file has 2 date columns(ShipDate and PurchaseDate) with timestamp. I am loading the excel data into a qvw file and applying PurchaseDate-ShipDate as ResponseDate. Now ResponseDate column is not giving me the difference for all rows. It is giving me the difference in 1 row only, in rest 2 rows it is giving me -(Hyphen).
Please help me on this. I want the difference in minutes.(Attached qvw file and excel file both)
Re: Qlikview is taking date column as text from excel
Your Timestamps are misbehaving in Excel:
The Timestamp of: 4/10/2008 10:21:00 AM is Apr 10, 2008 at 10:21 AM - this is a valid timestamp in ExcelThe Timestamp of: 14/06/2013 11:23:05 AM is NOT a valid timestamp in Excel - the month can't be 14 - it is being read in as a string
The Timestamp of: 03/08/2013 21:12:00 PM - this is NOT a valid timestamp in Excel - when you use PM, the hour can't be 21 - it is being read in as a string