Custom Field That Displays a Date Value Shows Extra Spaces on Edit Mode

SCENARIO

• A custom field uses the formula to_char(sysdate, 'Month DD, YYYY') to display the System Date in this format: Month DD, YYYY
• The value displays correctly on View mode
• On Edit mode, extra spaces appear between the Month and Day resulting to this output:
  January       23, 2013
  
  

SOLUTION

To remove the spaces between the month and date when viewing the field on Edit mode, change the custom field's Default Value to this:

TO_CHAR(SYSDATE, 'FMMonth DD, YYYY')

Extra spaces will no longer appear and the output will be the same on both View and Edit modes.