1 Reply Latest reply on Mar 11, 2010 9:29 AM by philmodjunk

    How to send an automated message



      How to send an automated message


      Hi, i m using filemaker for some marketing datra. now there is a field of call back date i want a script in a way tht it sees if current date matches tht date then all records tht contain todays date in call back date should be popped up. im having trouble in doing so. any help appreciated. thanks.



        • 1. Re: How to send an automated message

          There's a function that returns the date from your system clock: Get ( CurrentDate )


          Thus you can compare this to a date field (must be type date) like this: If [ Yourtable::YourDateField = get ( CurrentDate ) ]


          You can perform a find for dates with today's date like this:


          Enter Find Mode [ ]

          Set Field [YourTable::YourDateField ; get ( CurrentDate ) ]

          Perform Find []