I need to unzip the zip file on daily basis, while unzipping need to enter the password
“which will be in the format “Fis_MMMyy” in lower case.
The input file will be day-1 file i.e today we need to do automate yesterdays process.
if today is dec 1st then I need to do automate for 30th nov input files.
Till yesterday the process was working fine but today it is giving the error password is incorrect this is because instead of typing “Fis_nov21” it is typing “Fis_dec21”
on every month 1st I need to enter previous month password.
for ex today is Dec 1st, so I need to enter Fis_nov21 as a password, from dec 2nd I need to enter “Fis_dec21” till 1st of jan 2022 and so on.
Someone please do needful.
My logic=” “Fis_”+date.Now.ToString(“MMM”).ToLower+date.now.ToString(“yy”)"
Use like this below it will give today Fis_nov21 and tomorrow it will enter Fis_dec21 month.
You can use Kiran’s solution. I checked it works as per your requirement
Thanks and Regards,
So you can give the condition to it
If New DateTime(Now.Year,Now.Month,1).ToString(“dd/MM/yyyy”) = Date.Now.ToString(“dd/MM/yyyy”)
- Type Into : "FIS_"Date.Now.AddMonths(-1).ToString(“MMMyy”).ToLower
- Type Into : "FIS_"Date.Now.ToString(“MMMyy”).ToLower
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.