Unable to format dates in Excel reports

To format the date in the report as required after export to excel, please follow the below mentioned steps: Select the column with the dates in the Excel spreadsheet. Select Data tab on the menu bar and click the button that says ‘Text to Columns’. A wizard will now appear. Select ‘Delimited’ in Step 1 click ‘Next’,…

Editing the Planned End Date and Status

The planned end date column (P End Date) is filled with the dates from the End Date column. If a planned end date is recorded, a Status must also be recorded. If the student has left the course because they have left the school, the status should be set to Withdrawn, by selecting from the…

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…