Combining 2 dates to write in a field

[mybers]

Hi folks!

just having a dilemna on this, a form that has a subform. on the main form there's a First date and a last date fields, Now on the subform a field named: remarks I would like to placed the code on the after update event, when updated it will update/write in the field: [Issue date cert] the values of the first date and the last date.

Below is the sample code to update the [Issued date cert]

'Me.[Issued date cert] = Format(Forms!SS_TRNG!first2, "mmm dd, yy") & "-" & Format(Forms!SS_TRNG!last2, "mmmdd, yy")

Am I missing anything here?
Im being prompt with Run time error '2113'
The value you entered isn't valid for this field

Thanks in advance

 

[ck1999]

Make sure the format of the [issued date cert] is not a date format

Chris