Some Dates in my Medical file has the time, I would like to delete all the times and leaving the Date only. Is there a script to do that or any other suggestions .Thanks
This isn't really and issue post and would have been better served in the Filemaker Pro forum. ;-)
You can use the GetasDate function to extract the date from the timestamp field with data and time. If this is a permanent change to your database that you want to make, do the following:
I followed the above instructions to point 6, and nothing transferred from the old "Day_month" field to the new "Date" field. So I went through it again. So thinking point 7 may reveal all, I proceeded. Well, the Day_Month column is gone and the Date column is blank. I have a back up, but what step did I not get right?
I opened my back up file and the old "Day_Month" field sorted perfectly, which makes me think, I must have caused some sort of corruption in my current file since I made the back up two days ago. Thanks very much for your help. Learning my way round replacing fields will be helpful in the future I'm sure.
Retrieving data ...