Number 41564 to date

[#1]

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

[#2]

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

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

[rbecher]

Just use:

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

[#4]

Hi,

Please Try this

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

Hope it helps you

[Clever_Anjos]

Maybe your DebDocumentBetaalDatum has some spaces,

I would do

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

[Anonymous]

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

Regards,

Michael