How to delete the time from a timestamp and script a find of the last 2 weeks?
I'm using FMP11 Advanced on Windows 7 and I have a timestamp field (on creation) that I need to be a date field now.
(we realized that the creation time is not much important for this table in our database)
To change the field is not a problem (from timestamp to date), but now I have many old records with date+time as the timestamp did in the past.
I want to be able to make a script to search in this field (creation date on "calls" table) to find all the records (Customers table) over 14 days ago.
(this date field is in a portal on the Customer page to record all the calls we make to every customer and the staff will be able to get the customers to call - last time called 14 days ago).