Originally posted by Nucleus


No, as I do not want the function to alter the value passed to it.
According to your line of Code you set the Value of the Function as such:
StartDate = Date1

Are you trying to pass-back the value they already sent you?


And onto dw85745 question, the answer is its quite simply irrelevant. If MS has designed VB to handle Dates & Times at the same time in the same variable, that's great so be it.

This is why (for display purposes) the Format function is most Valuable.