Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Not applicable

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

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

Highlighted
MVP & Luminary
MVP & Luminary

Just use:

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

Vizlib Head of R&D
Highlighted
Not applicable

Hi,

Please Try this

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

Hope it helps you

Highlighted
Employee
Employee

Maybe your DebDocumentBetaalDatum has some spaces,

I would do

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

Highlighted
Champion III
Champion III

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

Regards,

Michael