topic Re: Max on text date in QlikView

Max on text date

rido1421 — Thu, 11 Sep 2014 09:38:48 GMT

Hi There

I am trying to get the max date on a date that is text

my date format is '201407'

Max dat on this is fine but I want to display it as July 14

variable, Max(DMonth)

below is my expression.

='Last Month '&'('&vMaxMonth&')'& ' Payment '

Load

DMonth,
Month(Date(Date#(DMonth,'YYYYMM'),'MMYYYY'))&'-'& Right(Left(DMonth,4),2) as [Text Month]
Resident Debtors;

how can I achieve this?

Regards,

PrashantSangle — Thu, 11 Sep 2014 09:41:29 GMT

Hi,

Write

Date(Date#(DMonth,'YYYYMM'),'MMMM YY')

Regards

sundarakumar — Thu, 11 Sep 2014 09:50:45 GMT

Hi Try this

month(right(DMonth,2)&'/'&'01'&'/'&left(DMonth,4))

-Sundar

rido1421 — Thu, 11 Sep 2014 09:53:38 GMT

Thanks you