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