Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
New Contributor III

Date conversion is not working

Hello everyone,

i am taking timedate from SAP database with a query


which is in the format as DD.MM.YYYY


for taking count i converted this in qv script like


Date(Date#(DateField),'DD.MM.YYYY'),'DD/MM/YYYY') as Date But when i do that i get an empty field.

I still have the date in the front end of the qvw but i would like to filter data.

SO this is a bit annoying


What might be the reason


please help me




Labels (1)
1 Reply

Re: Date conversion is not working

approach seems right but i see a mistake in your syntax i removed ) after DateField below

assuming that's just typo here not on the actual script.
load DateField by itself and check what the datatype comes as