AnsweredAssumed Answered

Date Formatting

Question asked by Jon1009 on May 3, 2010
Latest reply on May 4, 2010 by comment_1


Date Formatting


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.