IMPORT FILE ACCORDINT TO DATE OF MONTH 1

[villica]

I can't seem to figure out this one one
On a daily basis an excel file gets exported to an access table. Exporting the file is the easy part. this is my issue. the files are name according to the date
for example. todays file is call open030206, yesterday was called open030206.
So today I need to export the file that was created yesterday 030106. Yesterday I need it to export 022806. It gets tricky because a different month. Any ideas how can i do this.

suggestions please

thanks
Ana

villica

 

[mp9]

Format(Date(),"mmddyy") returns 030206 today.

Format(Date()-1,"mmddyy") returns 030106 today.

"Open" & Format(Date()-1,"mmddyy") returns Open030106 today.

In other words, you can always use "Open" & Format(Date()-1,"mmddyy") in either VBA or a query to return the string you need.

http://www22.brinkster.com/accessory/

 

[villica]

thank you so much. it works great

villica