converting Decimal to date

[#1]

Hi,

I am new to qlikview ,could you please answer me the below query

How to convert a decimal field 'A' where A=41129.666667 into a date field having the format 'DD-MM-YY'

[#2]

TRY THIS

=date('41129.666667','DD-MM-YYYY')

[#3]

TRY THIS

=date('41129.666667','DD-MM-YY')

OR TRY THIS

date(A,'DD-MM-YY') AS DATENEW

[#4]

Thanks for the reply, the solution provided works when the data is hard coded but I would want to specific the field or Column Name like date(A,'DD-MM-YYYY') where” A” is the name of the column or field where the data resides. So could you please let me know how this could be achieved

[MayilVahanan]

HI

I think , your date format is in string rather than number,

so , please try like this

= Date(Date#(A,'DD-MM-YYYY'),'DD-MM-YYYY')

Hope that helps

[#6]

in script write this

load *,

date(A,'DD-MM-YY') AS DATENEW

from table;

[#7]

= Date(Date#(A,'DD-MM-YYYY'),'DD-MM-YYYY') solution is not working

Is it possible to achieve this functionality through front end and not by changing the load script

[#8]

on front end,

in pivote table/straighttable

try this

date(A,'DD-MM-YY')

YOU CAN ALSO CHANGE THE DATE FORMAT ON FRONT END, EITHER IN TABLEBOX  OR STRAIGHT TABLE OR PIVOTTABLE OR OTHERS

SEE ATTACHED IMAGE

[MayilVahanan]

HI

If vishwaranjan solution not make sense, then can u post a sample ?

[Kushal_Chawda]

Hi,

You can try this :

date( A, 'DD-MM-YYYY')

Same you can use on front end as well.

You can also share test application if it's not working.