Fnd_Date_StringToDate

            Fnd_Date_StringToDate (date as text{; date format}) ➜ Date

              Parameter                Type              Description
              date as text             Text              Text of date to be converted to a date
              date format              Text              Date format (optional)
              Function result          Date              Converted date
            This function returns the date equivalent of the string passed. The input can be in any of these formats:
            M/D/Y, D/M/Y, Y/M/D and Y/D/M. Two digit years are resolved as per the SET DEFAULT CENTURY
            command. Dates can be entered with any character as a delimiter. If no year is entered, the current year
            is assumed. If only a one or two digit number is entered, the current month is assumed. If no delimiter is
            used, the following formats are supported (M/D/Y format):
              070476 Returns a date of 07/04/76
              07041976 Returns a date of 07/04/1976
              0704 Returns 07/04/00 (If this is in fact the year 2000)
              04 or 4 Returns the 4th day of the current month
              74, 704 and 074 are not supported
              "Today" returns the $today_date
              "Yesterday" returns the $today_date -1
              "Tomorrow" returns the $today_date +1

              $date_d:=Fnd_Date_StringToDate ("07/04/76")