date validation with user settings

Hi

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 ...