Hello Iam running Filemaker10 on Vista.
I need to create a code like GMG01-030510-01 the middle bit is the date which comes from a date created field but all I can get is GMG01-03/05/10-1 how can I get the date without the / ?
Ive setup the date created field to come but as 030510 but when its put though the calulation (Client Code &"-" & Date &"-01") its has / in it
Ive also tried a calculation with the Day ( date ) Month ( date ) Year ( date ) function but then i get GMG01-352010-01
Any help would be great.