Can you go further into the issue? You can seperate out the time and date.
Thank you for replying.
I would like to be able to display on the date or time in a timestamp field and also when a user clicks in to the field that they only see a date or a time.
Using the layout options it is possible to show only the time, but when a user clicks into the field, both the date and time are shown.
As the fields are coming from an SQL table on a coporate database I can't change them there. In the current 4D front end it is possible to view the date and time seperately, so the system has been set-up on that basis. So far the only solutions I can see, involve lots of related tables to allow the use of date and time fields and the scripttrigger activated scripts to move the values into the timestamp fields in the SQL database.
I'm hoping there is a better way as there are a lot of timestamp fields in this database.
Unforunately, FileMaker only allow one to access the field as a timestamp. There is no native interface to seperate out each one.
One option may be to perhaps use a script trigger to pop open a global time field or a global date field to change it, and when it changes it would update your timestamp field. It shouldnt be incredibly hard I would think but I dont it wont be easy either.
That's what I thought, unfortunately as the field is in a SQL table I can't add a Global there, so it'll also have to be in another table linked via a relationship, etc, etc...
A global field can be accessed without a relationship.
I've decided to go the script-trigger route. When user enters the timestamp field, a script is triggerred that throws up a dialog with the current date or time value as appropriate pre-populating the free entry box, allowing the user to change it. The script then puts the revised date or time back into the timestmap field and moves to the next field in the tab sequence.