The following are 2 verions of formulas that I've tried in placing the long date on a report. I want the JUD_T_MEETING_NOTICE.MEETING_DATE to be displayed on the letter if Outcome_ID = 3.00 as April 29, 2009. The field's fomat in the table is 04/29/2009 and neither of the formula's below worked. I tried formatting the date as a separte formula, as shown in Formula #2 below, but the formatting defaults to the original DataType. Anyone have any ideas on how to format the date within the string in the formula?
FORMULA #1:
IF {JUD_T_MEETING_NOTICE.FK_OUTCOME_ID} = 3.00
THEN 'I received the enclosed report(s) for review. To resolve this matter, you must contact the office at ' & {@HallPhone} & ' to schedule a meeting to discuss the incident with me. This meeting must occur by ' & DATETIMETODATE({JUD_T_MEETING_NOTICE.MEETING_DATE}) & '. If you have a conflict with this deadline, please let me know as soon as possible to make alternative meeting arrangements.'
ELSE IF {JUD_T_MEETING_NOTICE.FK_OUTCOME_ID} = 9.00
THEN 'You missed your scheduled meeting.'
FORMULA #2:
IF {JUD_T_MEETING_NOTICE.FK_OUTCOME_ID} = 3.00
THEN 'I received the enclosed report(s) for review. To resolve this matter, you must contact the office at ' & {@HallPhone} & ' to schedule a meeting to discuss the incident with me. This meeting must occur by ' & ({@FormatMeetingDate}) & '. If you have a conflict with this deadline, please let me know as soon as possible to make alternative meeting arrangements.'
ELSE IF {JUD_T_MEETING_NOTICE.FK_OUTCOME_ID} = 9.00
THEN 'You missed your scheduled meeting.'