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

Updated:  04/06/2017 20:32
This page added:  29 December 2008