xp_cmdshell Date Parameter - Looks for File create Date of last modify date? While deleting files using xp_cmdshell, does the date column look for file creation date or last modified date?
If you are thinking about using the FORFILES command with the /D parameter, this uses the last modified date. Type FORFILES /? to get more info about this command. See also https://stackoverflow.com/questions/51054/batch-file-to-delete-files-older-than-n-days