From your example it looks like these numbers are being treated as strings, is that the case or are these actually numeric fields?There are different ways of doing this depending on what data type you are dealing with. If these are actually numeric fields and you are trying to format a date (that's what it looks like) you can use the DateSerial function.
DateSerial(YYYY, MM, DD)
or with your example:
DateSerial({PHPACCT.AAMCY},{PHPACCT.AAMMM},{PHPACC T.AAMDD});