User-Defined Functions

css navigation by Css3Menu.com

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-2024

Updated:  06/21/2024 07:42
This page added:  29 December 2008