2 Replies Latest reply on Apr 11, 2014 7:21 AM by MartinAhlqvist

    Updating dates



      Updating dates



           When reading this have in mind that I have just finished the Filemaker Training series so I'm very new to the program.

           However, I have a problem with updating/changing a couple of date records. I have a bunch of records from 2012-01-01 to 2012-12-31 that I want to change to 2013. I have tried to build a loopingscript that would do this for me without success.

           Can anyone help?

        • 1. Re: Updating dates

               A loop can do this, but replace field contents can remove the need for any script at all let alone a loop if this is a one time fix:

               1) Make a back up copy of the file just in case this produces results you didn't expect

               2) Perform a find or whatever to pull up a found set of just the records that you want to change

               3) Click or tab into the date field and select Replace Field Contents from the Records menu

               4) select the calculation option and set up a calculation patterned after this example:

               Date ( Month ( YourDateField ) ; Day ( YourDateField ) ; 2013 )

               This will keep the month and day unchanged but change the year to 2013.

          • 2. Re: Updating dates

                 Thanks alot! Works like a charm!