AnsweredAssumed Answered

How to delete the time from a timestamp and script a find of the last 2 weeks?

Question asked by paolobkk on Aug 2, 2010
Latest reply on Aug 2, 2010 by paolobkk

Title

How to delete the time from a timestamp and script a find of the last 2 weeks?

Post

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).

Thanks!

Outcomes