topic Re: Number 41564 to date in QlikView

Number 41564 to date

Tue, 10 Sep 2013 13:14:00 GMT

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')

Tue, 10 Sep 2013 13:19:02 GMT

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

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

rbecher — Tue, 10 Sep 2013 13:22:19 GMT

Just use:

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

Tue, 10 Sep 2013 14:11:08 GMT

Hi,

Please Try this

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

Hope it helps you

Clever_Anjos — Tue, 10 Sep 2013 14:41:55 GMT

Maybe your DebDocumentBetaalDatum has some spaces,

I would do

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

Anonymous — Tue, 10 Sep 2013 18:44:45 GMT

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

Regards,

Michael