Number 41564 to date - Qlik Community

Report Inappropriate Content · ‎2013-09-10

Hello,

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:

date([DebDocumentBetaalDatum],'DD-MM-YYYY')

Report Inappropriate Content · ‎2013-09-10

Remember to change your date format in your edit-script to DD-MM-YYYY

or try Date(NUM#(DebDocumentBetaalDatum),'DD-MM-YYYY')

rbecher · ‎2013-09-10

Just use:

date(date#([DebDocumentBetaalDatum]),'DD-MM-YYYY')

Astrato.io Head of R&D

Report Inappropriate Content · ‎2013-09-10

Hi,

Please Try this

Date(Num(Date#( [DebDocumentBetaalDatum],'DD-MM-YYYY') )) As FieldName

Hope it helps you

Clever_Anjos · ‎2013-09-10

Maybe your DebDocumentBetaalDatum has some spaces,

I would do

date(trim(DebDocumentBetaalDatum),'DD-MM-YYYY')

Anonymous · ‎2013-09-10

You don't need to convert anything. Just use number presentation as date. It is on the Document Properties, Number.

Regards,

Michael