(Solved) – Date Format for Macro


I wrote a Macro to simplify a process at work.

I am trying to figure out how to fix this date so when the macro is run it isn’t missing an “.”

ex) https://i.stack.imgur.com/MbaR9.png

here is my code:

 Dim currentDate As String
    currentDate = Left(Replace(Date, "https://stackoverflow.com/", "."), 5)   Right(Date, 2)

Leave a Reply

Your email address will not be published. Required fields are marked *