Max on text date

[rido1421]

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 · Accepted solution]

Hi,

Write

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

Regards

[sundarakumar]

Hi Try this

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

-Sundar

[rido1421]

Thanks you