when I concatenate a text field & " "&date field it's displaying the text
fine but displaying the date in serial number
e.g. location and date 01/01/2001
becomes location and 19283
How can I maintain the date format?