How do I modify the Date/Time format for eSIS?
The eSIS .PDE file is setup to use the default Oracle date format. If your extracts uses a different format, you will need to modify the .PDE file to use the correct format.
Here are the steps required to change the pde date format:
- Open the “student” file found in your import folder
- Look for the birthdate field and remember what the date format is. ie. mm/dd/yy or yyyymmdd
- Find the .PDE file in the import folder and open the the file using a standard text editor
- Locate the line “#pragma dateformat dd-mm-yyyy” near the top of the file
- Modify the dd-mm-yyyy value to match the date format used in your “student” file
- Save and Close the .pde
- Run Update Card from Principalm Connect to get the correctly formatted date information.