1 2 Previous Next 22 Replies Latest reply on May 12, 2014 7:03 AM by philmodjunk

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

    harp@joannajordan.com

      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!

        1 2 Previous Next