Skip to Content
0
Former Member
Apr 29, 2009 at 02:09 PM

Converting Date-Time to Long Date in a string that is stored in a formula

46 Views

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