Importing Date-Time from SQL server

[mopai]

I need to import a date-time field from an online SQL server DB to a local FM DB.

the date field on the SQL Server is of the following format

mm/dd/yyyyy hh:mm:ss tt

How do i get the full date-time into Filemaker date field

I only get mm/dd/yyyy

the time and am/pm are not added

thanks

[Lee Smith]

Your field should be showing the whole thing by what you posted (i.e. mm/dd/yyyyy hh:mm:ss tt). Usually the question is, how do I separate these into their own fields. Is this a database you have created? or one you inherited from someone else?

[-Queue-]

You would need to use a timestamp field to import a full timestamp. I am surprised that you can import a timestamp into a date field without causing problems though.