Numeric Integer conversation into date

[ranesaumitexpo]

i have a field in my database 23/01/2002 as $numeric and $interger. I want to convert that field into a date format. I tried to date(num#(datefield,'DD/MM/YYYY'),'DD/MM/YYYY') but it gives me. similarly, I have tried date(date#(datefield,'DD/MM/YYYY'),'DD/MM/YYYY') 

[sunny_talwar]

May be this

Date(Num#(datefield), 'DD/MM/YYYY') as Date

or just this

Date(datefield, 'DD/MM/YYYY') as Date

[ranesaumitexpo]

I tried what suggested @sunny_talwar still it gives null.

[sunny_talwar]

Can you share an image of the data when you load datefield without any transformations. We need to understand how does Qlik read it before performing any transformations to it.

[Or · Accepted solution]

You could try tagging your field as $date. This is sometimes helpful when the engine struggles to determine something as a date, usually when the field has values that extend into the distant past or future.

Tag Field FieldName as '$date';