Im uploading data from the excel file to internal table . Im facing the below mentioned problem in validation checking -
1. I need to check date provided in the excel sheet is aligned with user format or not. If not stop processing.
i.e If the user has dd/mm/yyyy as his setting then he will upload the file using this setting. If the setting in the file is set to say mm/dd/yyyy, then it will fail if the user setting is dd/mm/yyyy
same way I need to validate the amount field. As pert th user setting I need to check ',' or '.' for thousand separator.
PLease help me out ...