you can set a script step to perform a find where DayName (MeetingDate) = "Wednesday"
Then detect the no record found error and have it show the custom dialog.
Ok, I set it so that it would fail and I don't get a custom dialog box. Instead, I get a bunch of other boxes that ask me to revert field. I know I'm missing something simple.
I put the following in my script:
If [ Get ( LastError ) = 401 ]
Show Custom Dialog Box [blah blah]
Am I missing a parameter in my if statment?
You'll need a calculation field that uses Mark's calculation to return the day name of the meeting date. Then you set your script to search on that field rather than the meeting date field, specifying "wednesday", or just "W" as your search criteria.
Ok. Now I'm completely lost! :)
I also re-read my exercise and it is supposed to actually search for meetings today. So I used DayName ( Get ( CurrentDate )) as my search parameter. Well, that part works fine. But if I do change the DayName (MeetingDate) = "Saturday", then I can't get it to show the custom Dialog box.
I'll try creating a new field for my search parameters and using that to perform the find.
Searching for records with today's date does not require working with day names.
Enter find Mode  //clear the pause check box
Set Field [YourTable::MeetingDate ; get ( CurrentDate ) ]
Set Error Capture [on]
Perform Find 
IF [ Get ( FoundCount ) = 0 // no records found ]
Show Custom dialog ["No meetings with today's date were found."]
They specifically say to use the Dayname function and it still works that way because what they want is to get today's dayname and search ALL meetings on that criteria. So, today is Wednesday so they want to see all meetings on Wednesday.
So, I just modified your Set Field to the DayName (Get (CurrentDate)) and it works. I can change to fail and I get my dialog box.
Thank you very much!!!
Hmmm, that would only make sense if they want you to find all records on the same day of the week as today. That can be done, so read the directions carefully.
:) It looks like I was editing my response as you were answering.
Actually, I read your post, but was forgetting that you can use "Wednesday" as search criteria in a date field and was trying to complicate your solution with an uneeded calculation field.
Either way, you got me pointed in the right direction and it worked. I appreciate it!!