Fix Date
In our new system, we needed to pass dates from Excel or Access in a certain format. Turns out that I only need to write the function once and use it in either Excel or Access.
Function ViryaDate(aDate As Date)
ViryaDate = Format(aDate, "dd-mm-yyyy HH:mm")
End Function
I don’t know if Excel functions also work in Word; we will just have to try
|