Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Number 41564 to date

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')
5 Replies
Not applicable

Re: Number 41564 to date

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

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

MVP
MVP

Re: Number 41564 to date

Just use:

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

Not applicable

Re: Number 41564 to date

Hi,

Please Try this

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

Hope it helps you

Employee
Employee

Re: Number 41564 to date

Maybe your DebDocumentBetaalDatum has some spaces,

I would do

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

mov
Esteemed Contributor III

Re: Number 41564 to date

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

Regards,

Michael

Community Browser