Date conversion is not working

[lessassy]

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

[dplr-rn]

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