Discussion Board for collaboration on QlikView Scripting.
I have a datefield with values 41***, however I want to convert them to DD-MM-YYYY
How can I do this? I tried this, but it doesnt work:
Remember to change your date format in your edit-script to DD-MM-YYYY
or try Date(NUM#(DebDocumentBetaalDatum),'DD-MM-YYYY')
Please Try this
Date(Num(Date#( [DebDocumentBetaalDatum],'DD-MM-YYYY') )) As FieldName
Hope it helps you
Maybe your DebDocumentBetaalDatum has some spaces,
I would do
You don't need to convert anything. Just use number presentation as date. It is on the Document Properties, Number.