topic Re: converting Decimal to date in QlikView

converting Decimal to date

Thu, 08 Aug 2013 05:56:06 GMT

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'

Re: converting Decimal to date

Thu, 08 Aug 2013 05:58:19 GMT

TRY THIS

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

Re: converting Decimal to date

Thu, 08 Aug 2013 05:58:51 GMT

TRY THIS

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

OR TRY THIS

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

Re: converting Decimal to date

Thu, 08 Aug 2013 06:30:20 GMT

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

Re: converting Decimal to date

MayilVahanan — Thu, 08 Aug 2013 06:34:27 GMT

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

Re: converting Decimal to date

Thu, 08 Aug 2013 06:35:15 GMT

in script write this

load *,

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

from table;

Re: converting Decimal to date

Thu, 08 Aug 2013 06:43:33 GMT

= 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

Re: converting Decimal to date

Thu, 08 Aug 2013 06:47:44 GMT

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

Re: converting Decimal to date

MayilVahanan — Thu, 08 Aug 2013 06:50:09 GMT

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

Re: converting Decimal to date

Kushal_Chawda — Thu, 08 Aug 2013 06:58:34 GMT

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.