Date in graph (qlik sense)

[#1]

Hello I'd like to ask. I have data and one column is "date". Even if chagne its type to "timestamp or date" it doesnt work to use it in graph. Funny thing is - sometimes it automaticly recognize that it is date and sometimes it doesnt. I have always same data and same column names. i changed column with dates to "Date" and use "sys_created_on.autoCalendar.Date". It shows what is shows on picture below, which is lie. Dates are like "17.1.2013 21:50:30" Input format is "D.M.YYYY h:mm:ss".

Thanks for help.

[shraddha_g]

Try something like this:

Date(Floor(Date#(datefield, 'd.m.yyyy hh:mm')))

[sunny_talwar]

I think it would be helpful for you to read through these blogs:

Why don’t my dates work?

Get the Dates Right