I'm sorry guys, this is probably simple and I did look for a solution before posting this but I did not find one.
Currently I am setting the date I want to use in my filename like this.
MyDate = Format(Date, "mm-dd-yy")
The problem is I want this to display the day previous to today.
Sorry if that didn't make sence, so if today was
01-24-05
it would set MyDate to
01-23-05
Thanks in advance for any help you guys can offer.
Currently I am setting the date I want to use in my filename like this.
MyDate = Format(Date, "mm-dd-yy")
The problem is I want this to display the day previous to today.
Sorry if that didn't make sence, so if today was
01-24-05
it would set MyDate to
01-23-05
Thanks in advance for any help you guys can offer.