Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Try the function
date(floor(YOURDATEFIELD)) as CalendarDate (or whatever fieldname you want)
or just
floor(YOURDATEFIELD) as CalendarDate
Best Regards,
Alex
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