Date conversion is not working

lessassy — Sat, 16 Nov 2024 03:28:37 GMT

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

Re: Date conversion is not working

dplr-rn — Fri, 24 May 2019 16:16:41 GMT

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

topic Re: Date conversion is not working in QlikView

Date conversion is not working

Re: Date conversion is not working