AnsweredAssumed Answered

I want to see records modified yesterday

Question asked by emaven on Mar 4, 2013
Latest reply on Mar 5, 2013 by AlastairMcInnes

Title

I want to see records modified yesterday

Post

     I want to see records that were entered yesterday. 

     I have several different tables and use only one of them for this purpose. 

     I followed the directions from here  http://forums.filemaker.com/posts/2b429ffbcf?lang=en_US and added a few more steps of my own, but it doesn't quite work.

     The problem is with this statement:  Set field [Yourtable::yourdatefield, Get(currentdate) - 1]

     yourdatefield has the correct field name, but when I run the script, it uses another field in which to insert the date. At this point I get the message no records match. If I choose modify find, and manually cut the date from the wrong field, and paste it into the correct field, the find does work. 

     I have put the correct name into the script by picking it from a list in the correct table. But I can't figure out why it it does not use it when run.

      

      

Screen_Shot_2013-03-04_at_3.17.16_AM.png

Outcomes