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