Conversion of Varchar type(in MysqlDB) to Date format in Qlikview

[hamzabob1]

Dear All,

Briefly

DataSource             : Mysql

Table                      : XYZ

Field/Column Name : Application Date  (in Varchar format ) [EX:-01-01-2015 12:00:00]

Now after fetching the data into QlikView environment - Is is possible to change Application Date into DateFormat??

I have tried the following

1.     date#(date(Application_Date,'DD-MM-YYYY'))    -->  resulting Null values

2.     timestamp(Application_Date)                             -->  resulting Null values

3.     date#(SubField(Application_Date,' ',1),'DD-MM-YYYY')      --> Resulting data in DD-MM-YYYY format

Help me in the conversion of Varchar to date format in qlikview. The format should also be helpful in incremental load.

Thanks in advance!!

[arulsettu]

try this

date(floor(Application Date) as date

[jonathandienst]

If No 3 solves your problem, what is your question?

[hamzabob1]

Require in timestamp format like DD-MM-YYYY hh:mm:ss, which i can utilise for my data incremental

[arulsettu]

what is your current format?

[hamzabob1]

If i apply date(floor(Application_date) as date, the resulting is null when we populate date in list box.