topic Timestamp / Date format problem in QlikView

Timestamp / Date format problem

Fri, 15 Oct 2010 09:03:10 GMT

Hi,

Could someone please help me. The database I'm pulling data from shows a certain column as a date, eg. 25/09/2010. When this comes through to Qlikview, it shows as 25/09/2010 12:00:00 AM. Every date is showing 12:00:00 AM as a default time. I think this is affecting my calculation when I try subtracting two dates because it then gives me a decimal result such as 2.35 days etc.

What could be causing this?

tx,

Timestamp / Date format problem

sathishkumar_go — Fri, 15 Oct 2010 09:20:59 GMT

Hi SHANEJVW,

Use date function. ex : date(fieldname,'DD\MM\YYYY') AS FIELDNAME

Regards

Sathish

Timestamp / Date format problem

spsrk_84 — Fri, 15 Oct 2010 09:33:54 GMT

Hi ,

There might be a chance where your date is stored in timestamp format ..So no need to worry on that part.

1) Check your Date format in Qlikview script Main Tab i.e Set Date format ="DD/MM/YYYY" it should be like this else you just change the format settings as shown above..

2) Second thing what you can do like you just format your date field

Date( InvoiceDate.'DD/MM/YYYY') AS InvoiceDate

Hope this inforamtion will solve your problem ..

Regards,

Ajay

Timestamp / Date format problem

Fri, 15 Oct 2010 09:41:51 GMT

Thanks for the reply. I have tried ***Date(Last_Sales_date,'DD/MM/YYYY') as LSD*** but this isn't working. I've attached a copy of the file. Maybe I'm missing something. thanks, S

Timestamp / Date format problem

Fri, 15 Oct 2010 11:57:50 GMT

Try using this expressions:

Date(Left(Last_Sales_date,10),'DD/MM/YYYY')