Date Format Transformation Pseudocode

Pseudocode: Transform Date Format Based on Conditions

Purpose

Convert the DueToEMS_udvFieldVal to a specific date format when two other fields are NULL.

Conditions

• Both MR1_DueToEMS_udvFieldVal and MR2_DueToEMS_udvFieldVal must be NULL.

Actions

• Extract parts of DueToEMS_udvFieldVal to form a date in the format MM/DD/YYYY.

Pseudocode

IF MR1_DueToEMS_udvFieldVal IS NULL AND MR2_DueToEMS_udvFieldVal IS NULL THEN
    SET extractedYear = SUBSTRING(DueToEMS_udvFieldVal, 1, 4)
    SET extractedMonth = SUBSTRING(DueToEMS_udvFieldVal, 5, 2)
    SET extractedDay = SUBSTRING(DueToEMS_udvFieldVal, 7, 2)

    SET formattedDate = extractedMonth + '/' + extractedDay + '/' + extractedYear
END IF

Explanation

1. Condition Check:

   • Verify that both MR1_DueToEMS_udvFieldVal and MR2_DueToEMS_udvFieldVal are NULL.

2. Substrings Extraction:

   • Extract the year (first 4 characters).
   • Extract the month (5th and 6th characters).
   • Extract the day (7th and 8th characters).

3. Format Concatenation:

   • Concatenate these parts in the order MM/DD/YYYY.

The pseudocode ensures that the transformation only occurs when both specified conditions are met, adhering to common logic structures for better readability and understanding.