Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
ecabanas
Creator II
Creator II

Problem with dates

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

2 Replies
Not applicable

Hi,

Try the function

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

or just

floor(YOURDATEFIELD) as CalendarDate

Best Regards,

Alex

hic
Former Employee
Former Employee

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