As I work in Canvas the challenge I am running into is getting the Start and End dates to be in the YYYY-MM-DD THH:MM:SSZ format in my CSV files. My process of creating the Courses CSV file for a manual SIS Import is to pull a report from our lead management system called Flatbridge that contains the course id, short name, long name, start date, and end date. When I pull the dates from Flatbridge they are in the MM/DD/YYYY format. To change the date format I created a Custom Number Format in Excel that allows me to use the required format listed above.
When I save the spreadsheet none of the adjustments I made to the start and end date column previously is saved and therefore I am not able to import the CSV file into Canvas successfully.
Does anyone have recommendations on how I can get the start and end dates to remain in the required format in Excel?