topic Re: Problem with dates in QlikView

Problem with dates

ecabanas — Thu, 24 Jan 2013 07:58:01 GMT

Hi everyone,

I have a mastercalendar that contains dates from 01/01/2011 till today. I have a tables imported from Mysql and I could not manage the data with the date, there is any script code to import the date with the same format from the rest of the tables?

I saw the data inside and has the same format or structure...

Thank's

Eduard

Re: Problem with dates

Thu, 24 Jan 2013 08:06:55 GMT

Hi,

Try the function

date(floor(YOURDATEFIELD)) as CalendarDate (or whatever fieldname you want)

or just

floor(YOURDATEFIELD) as CalendarDate

Best Regards,

Alex

Re: Problem with dates

hic — Thu, 24 Jan 2013 16:50:52 GMT

You need to make sure that the dates are interpreted as dates. Usually this works automatically when loading from ODBC. Check by creating a list box with dates. If they are right-aligned, they are most likely correctly interpreted. If they are left-aligned, you need to read the pdf on http://community.qlik.com/docs/DOC-3102 and then use an interpretation function like date#().

HIC