AnsweredAssumed Answered

Can someone please tell me how to convert a DATE field to text field displaying Month, Day, Year?

Question asked by harp@joannajordan.com on May 9, 2014
Latest reply on May 12, 2014 by philmodjunk

Title

Can someone please tell me how to convert a DATE field to text field displaying Month, Day, Year?

Post

     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

     Thanks!

Outcomes