Timestamp / Date format problem

[#1]

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,

S

[sathishkumar_go]

Hi SHANEJVW,

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

Regards

Sathish

[spsrk_84]

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

like

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

Hope this inforamtion will solve your problem ..

Regards,

Ajay

[#4]

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

[#5]

Try using this expressions:

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