How to convert Date to String?

[thebaul]

Hello

I am trying to create an order ID field based on the 1st 3 letters of the name of the buyer and the date of purchase. For example, if the buyer is James, I want the order ID to become JAM010112 (If the date is 01/01/12). How do I go about doing this?

[JoeM]

Try this:

ID:LEFT([Buyer],3) & FORMAT([Purchase Date],"mmddyy")