WRQ Reflections Timestamp Code

[Robertson1995]

Hello. I need a code for WRQ Reflections that will post a Msgbox with a message and the current timestamp.

Example:

Msgbox would say:

The Maintanance Window is 11pm-5am. The Current Time is "timestamp"

Is this possible in Reflections?

 

[hoosiergoody]

Try this:
Sub testing()
MsgBox "The Maintanance Window is 11pm-5am. The Current Time is " & Format(Now, "hh:nn:ss")
End Sub

I was able to get it to read back the current time as 22:26:35. To get it to say 10:26pm may take a bit more research, but probably could be done in the formatting portion...

Hoosiergoody

 

[Robertson1995]

Thanks for your help. That worked great. Military time is fine.