Search results

These functions run daily to be part of automating a process. They they are used to automate pulling files off an sFTP site and placing them locally. My customer makes reports manually and only supplies files M-F. They can be altered by changing the CASE offset to have start day of the week to...

I may not be able to reply all the time. Our internet security team has blocked my last two replies.

I know it is an old thread, but these get hit all the time with searches. I have two functions that are easy to read and easy to test that will return either day or date and can be called within a query: EDIT: Lost my formatting when placed as preformatted text. Open to suggestions...

Thank you!

Hey everyone! I am an old geez with 20+ years of IT experience, mostly programming. Access is a tool I haven't used much in the past, but that doesn't stop me. I research how to do things in ways that others apparently haven't done, so often have a unique spin on how to make things work. For the...