Field: RPQ End Date



Field: RPQ_End_Date

Field: RPQ_End_Date
Type	Datetime
General Description	The end date of a questionnaire answer sheet (resource project questionnaire) is normally the date and time that a user finished filling in a questionnaire.
Import Group	Import Data (by selecting a questionnaire)
Business Rules	Questionnaire end date must follow the format of general date time; namely: “yyyy-mm-dd hh:mm:ss” Importing questionnaire start date is compulsory if you specify ‘completed = true’ in questionnaire completed ‘column’. Questionnaire end date must not be greater than current date To update this field for existing users, you must select a User_Id column in step 1 of the import wizard and also map to the specific questionnaire answer sheet that you want to update. If you choose option 1 in step 2 of the import wizard, any existing questionnaire start dates will be overwritten with the new start date If you choose option 2 in step 2 of the import wizard, all existing questionnaire will be deleted so the start date will always be that of a new answer sheet If you choose option 3 in step 2 of the import wizard, the exact answer sheet to which you mapped will get overwritten with the specified start date
Validation	Error message is shown if you try to import wrong format of date time. Error type: ERROR (the import job will not be allowed to be executed). Validation error: ‘Questionnaire Start Date must not be greater than Questionnaire End Date’ will be shown if you try to import to start date a value that is bigger than end date. Error type: ERROR (the import job will not be allowed to be executed). Validation error: ‘Questionnaire end date must not be empty in case you specify a questionnaire answer as completed’ will be shown if you try to import completed value to Questionnaire without end date mentioned. Error type: ERROR (the import job will not be allowed to be executed).
Notes	See questionnaire start date for more information. Please investigate the file on import wizard to learn more on importing questionnaires data.