This content has been marked as final. Show 4 replies
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