Question:
When creating a Message Box with the date, a random numeric value is displayed (for example, 39876,8934523). How can I set up the Message Box with the Date/Time format?
Solution:
To do so, you can use the CDate() method to convert the number to the Date/Time format. For example:
Sample script being executed at a button’s Click event:
time = CDate(Application.GetObject(“Data.CurrentTime”).Value)
MsgBox time
MsgBox time
