Time vs Date - consistency issue in vba

[lezawang]

Hi
I just wanted to know why excel is not consistent here. I wrote the code below. When I call Data() excel will remove () and keep Date only; However when I used Time(), excel will keep the ()

It is not big issue but curious why there is not consistency here.

Sub mytest2()
    MsgBox Date
End Sub

Sub mytest3()
    MsgBox Time()
End Sub

 

[Rijnsent]

Hi Lezawang,
quite an interesing quirck you found! I've been digging, but can't find any logic behind it, just that the VBA editor changes the Date() to Date automatically and it doesn't do the same for Time(). Weird, because both statements are quite the same, they don't take arguments. If you want your code to be consitent, go for Date and Time.
Cheers,
Koen