topic date format in QlikView

date format

Anonymous — Tue, 21 Jan 2014 14:20:34 GMT

hi,

i have feild like this "yymm" (1401)

how can i chenge it to the lest day of the month in this format : "dd-mm-yyyy "

in the exm. it should be 31-01-2014.

thanks'

yarin.

Tue, 21 Jan 2014 14:31:20 GMT

Try this:

=Date(MonthEnd(Date(Date#(TestDate,'YYMM'),'MM-YYYY')),'DD-MM-YYYY')

jagannalla — Tue, 21 Jan 2014 14:33:57 GMT

Hi,

Try this

Load

Date(MonthEnd(MakeDate(Left(DateField,2),Right(DateField,2))),'DD-MM-YYYY') as Date

from table

Cheers!!

Jagan