Hi,
I am using VCRON to decrypt & rename files. The issue I am running into is when a client sends us a file that includes a time stamp.
Example: PQ.g1845.PSF.ELIG.a1.dt090414221608.pgp
The date and time stamp change each time the cleint sends the file. So I formated the job to find the file PQ.g1845.PSF.ELIG.a1.dt{DATEFORMAT(yyMMddhhmmss)}.pgp and rename to 1845ELIG_{DATEFORMAT(yyyyMMdd)}.txt the job fails stating it could not find the file. I have tried all kinds of variations all with the same result. I know the issue is the time stamp because I have no issues with files that have dates only. What do I need to do to make this work? Thanks, Eileen 😕

There is a very high risk that the Task will fail because if you use PQ.g1845.PSF.ELIG.a1.dt{DATEFORMAT(yyMMddhhmmss)}.pgp it will look for the exact second (as DATEFORMAT formats now). It will probably not find anything unless you have second timing. I think you have misunderstood the usage of DATEFORMAT. It seems ok at destination file but not at source file.

I think you are making it hard for yourself. Either you should use a file mask like this: PQ.g1845.PSF.ELIG.a1.dt*.pgp or you should base the action on Events instead of time. So, use the File trigger instead and grap the path and file name from the Variable of the File trigger.

---