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
below is my expression.
='Last Month '&'('&vMaxMonth&')'& ' Payment '
LoadDMonth,Month(Date(Date#(DMonth,'YYYYMM'),'MMYYYY'))&'-'& Right(Left(DMonth,4),2) as [Text Month]Resident Debtors;
how can I achieve this?
View solution in original post
Hi Try this