2 Replies Latest reply on Jan 12, 2015 10:28 AM by erawson

    timestamp records from an ODBC connection cannot be formatted?

    bvondeylen

      Title

      timestamp records from an ODBC connection cannot be formatted?

      Post

      I have a table from an SQL source via ODBC that has a birthdate field that is of type timestamp.

      When I place this field on a layout, I would like to format the field like Dec 25, 2015, but it doesn't work. The field displays as 12/25/2015 12:00 AM

      If I attempt to format the TIME part, that works, but my options are limited. I only want to display the DATE, not the TIME, but FileMaker doesn't give the option of NOT displaying the TIME in the timestamp field.

      Since this table has over 200,000 records, I don't want to create a Calculation field just to duplicate the birthdate field and make it a DATE field. Since kinda overkill. Is there another option?