August 17, 200520 yr Here's one for you all. I've created a database that records all of my webpage hits. The data is imported via the Troi URL plugin. This being said the user enters the previous Saturday's date into a field and the script implements that date into a URL address and that entire week is brought into Filemaker. What I want to do is create an automation script: - to run anytime after the last update - And that inserts any of the missing Saturday's dates since the last update. I guess what I really need is some sort of calculation that can determine the Saturday's date (perhaps based off of the week number) ANY help or information you can provide would be greatly appreciated!
August 17, 200520 yr If your updates are always run with a Saturday date, then nextUpdate could be simply lastUpdate + 7.
Create an account or sign in to comment