Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
lessassy
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

 

regards,

Yann

Labels (1)
1 Reply
Partner
Partner

Re: Date conversion is not working

approach seems right but i see a mistake in your syntax i removed ) after DateField below
Date(Date#(DateField,'DD.MM.YYYY'),'DD/MM/YYYY')

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