Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 4817 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

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. post-105412-0-42391400-1317682723_thumb.

Posted

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.

This topic is 4817 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.