Can someone please tell me how to convert a DATE field to text field displaying Month, Day, Year?
I would like to have a field in my database that converts a DATE field from 05/09/2014 to May 9, 2014
My plan is to have two different fields, one left as a DATE field from which I get the data to replace records into the DATEASTEXT field and
I need this DATETEXT field for form letters
I tried using the Inspector to display the DATE as May 9, 2014, but in the layouts it appears as 05/09/2014