Post a reply

Options
Add an Attachment

If you do not want to add an Attachment to your Post, please leave the Fields blank.

(maximum 10 MB; please compress large files; only common media, archive, text and programming file formats are allowed)

Options

Topic review

RBlakeney

get -latest based on current date

Using VBA, I have a script which grabs the latest file from the server. It uses a wildcard to grab the correct titled file and the get - latest pulls the most recent.

I need to expand this so that it only pulls the latest file with the current days timestamp.

This is so that on the next day, it doesn't grab one of the files that would have been grabbed yesterday if a newer file has not been created on the server. Yesterdays file have been processed and removed locally and we do not want them processing again.

I assume I need to something like this but am unsure of the syntax:

- Get todays date
- Get the latest file with todays timestamp

Any ideas?