Date help needed

gunkel · Post by **gunkel** » Mon Oct 03, 2005 10:19 pm

Hi
I am not very familar with programming.
I want to built a macro. The job is do delete a file with the name
fileyyyymmdd.zip.

yyyymmdd is the date of yesterday.

Thanks for any help

KG

Me_again · Post by **Me_again** » Tue Oct 04, 2005 12:33 am

There is some great help information provided with MacroScheduler that you should find helpful. Date formats can be tricky but support provided some great examples in this thread http://www.mjtnet.com/usergroup/viewtop ... =yesterday

Based on that info here's how to generate the filename you specified

VBStart
VBEnd
VBEval>Year(date()-1)&Month(date()-1)&Day(date()-1),yesterday
Let>myfile={"file"+%yesterday%+".zip"}
MessageModal>%myfile%

Once you have the filename part working then look at the "DeleteFile" command in the Help and you should be in business.