User-Defined Functions

css navigation by

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

© 2008-2023

Updated:  09/16/2023 18:53
This page added:  29 December 2008