Saturday, February 23, 2019

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


  • 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


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:


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

No comments:

Post a Comment