Thanks a lot Problem solved!!!!! :):):)
Can i ask you something else please :)
I am getting the file of the previous date... What can i do for the 1st of the month.. As on the first of the month i have to get the file of the previous month
For example FIle Name: DailyLoyaltyRakes_{DATE(Month.Name)}_{DATENOWADD(Days,-1,dddd)}_{DATENOWADD(Days,-1,%d)}.txt which gives DailyLoyaltyRakes_December_Monday_15.txt
But what if its the first of the month and i need to get the file of the end of the previous month??