Purchase Master report

Hi there

i have a few small clients that use the free version with the default containers created

when the use the purchases master and they add docdate they always get 11th of the month

below is your formula for the date expression spot the issue

CAST(SUBSTRING(CAST("POHSTL"."TRANSDATE" AS CHAR(8)), 1, 4 )+'-'+
SUBSTRING(CAST("POHSTL"."TRANSDATE" AS CHAR(8)), 5, 2 )+'-'+
SUBSTRING(CAST("POHSTL"."TRANSDATE" AS CHAR(8)), 3, 2 )AS DATETIME)

now this is not a problem for me i have a connector lic so i can edit thi formula but they can not

please advise as your purchases master report date formula is not correct it should be 7,2  

accpac date  = 20110714

your formula will bring 2011-07-11 because of  "AS CHAR(8)), 3, 2 )AS DATETIME)" its showing the lst 2 chars of the year

please advise