I have generated a report from a query. There is a field which stores "Year and Month" in the format "YYYYM" and is text type.

But when it is shown in report, i want it to be displayed as "YYYY-M".
is it possible??
if yes, how should i do it?

my first priority is to change the format in the report itself rather than changing it in the table and/or query.

Thanks in advance.

Get rid of Input Mask that is not correct way to do it.

For type text this should work.

@@@@-@