How to format dates in Excel reports.
When report is run the date of birth will show i.e 21st January 2001 would like the format to be 21/01/01. To format the date in the report as required after export to excel, please follow the below mentioned steps: 1. Select the ‘DOB’ column in the Excel report output. 2. Go to Menu Data…