FW JOB TO FIND THE FILE WITH "FILENAME MMYY"

[master4usrcm]

Hello All,

My Filewatcher job has to look for a file with name "filename MMYY" where it has to look for previous month.
Ex: In May it has to look for "filename 0410"

So for this I have used auto edit variables as below.

For Year I have selected as %%YY=%%SUBSTR %%$ODATE 3 2

but how should I extract the month with previous month value.

I cannot use %%MM=%%OMONTH - 1.

Can anyone please help me in this??


Thanks & regards

[hipikll]

I do not know, if i remember clearly, but ...

try to look for the CALCDATE in manual.

[Walty]

Hi,

Suggestion:

%%MY_VAR=%%$CALCDATE %%$ODATE -%%ODAY
%%MY_YEAR=%%SUBSTR %%MY_VAR 3 2
%%MY_MONTH=%%SUBSTR %%MY_VAR 5 2
%%MY_LAST_MONTH=%%MY_MONTH.%%MY_YEAR

[master4usrcm]

Thanks Walty I appreciate.....