4 Replies Latest reply: Jul 16, 2013 5:23 AM by Nur Syafiqah RSS

    Formatting dates in text boxes

      Hi All,


      I have a text box which displays the date from a listbox called 'Reporting_Date_Comp' when a date value is selected.

      However, the values are not formatted.


      For example, when I select '20130504' from the listbox, it will be displayed as 'Date: 20130504' in my text box.

      Is there a way for me to format it such that it will be displayed as 'Date: 04/05/2013' instead?


      Below is my working code in the text box:


      ='Date: ' & Reporting_Date_Comp