mongoose
07-20-2019, 04:27 AM
I have a set of files that follow the following naming scheme:SOP_Audit-JV-006-02182019.docx
The last part of the file name is a date that I want to pull into VBA, which I have working fine using Split(). Is there something similar to this: https://www.php.net/manual/en/function.date.php in VBA? Something that would allow me to convert that string to a date and then be able to format it differently, or compare it with another date, break it down into just the month or year, etc.
I was reading about the CDate function and trying to use that but am having some issues with it.
Thank you!
The last part of the file name is a date that I want to pull into VBA, which I have working fine using Split(). Is there something similar to this: https://www.php.net/manual/en/function.date.php in VBA? Something that would allow me to convert that string to a date and then be able to format it differently, or compare it with another date, break it down into just the month or year, etc.
I was reading about the CDate function and trying to use that but am having some issues with it.
Thank you!