I have an ODBC connection to a MSSQL database that has several timestamp fields. In FM, I'd like some of the fields to display just the dates and other fields to display just the times. When I use the Inspector/Data Formatting area to make any changes, the changes do not stick - the fields always show both the date and the time regardless of my changes.

I'm not sure if I am doing something wrong in FM or running into a limitation based on my data source.

Any thoughts or work-arounds?

Picture example of ODBC data source fields attached.

I thought the ODBC data source types were fixed, dependent on the source, but they are not. FM can apparently interpret a timestamp as either a date or a time. So, all I had to do was change the data type from Manage Database.