Select case Time() ? (1 Viewer)

smig

Registered User.
Local time
Today, 08:20
Joined
Nov 25, 2009
Messages
2,209
I want to use Select case Time() for a Welcome screen, Like good morning, Good evening... etc

What is the correct format for this ?
 

Gasman

Enthusiastic Amateur
Local time
Today, 06:20
Joined
Sep 21, 2011
Messages
14,238
I use this in my Outlook
Code:
   iTime = Val(Format(Now(), "hh"))
  
    ' Quit if not a mail item
    If TypeName(Item) <> "MailItem" Then
        Exit Sub
    End If
    
    Select Case iTime
    Case Is < 12
        strGreeting = "morning "
    Case Is < 17
        strGreeting = "afternoon "
    Case Else
        strGreeting = "evening "
    End Select

    strGreeting = "Good " & strGreeting

HTH
 

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 22:20
Joined
Oct 29, 2018
Messages
21,455
How about?
Code:
Select Case True
    Case Time()<#12:00 PM#
        'morning
    Case Time() Between #12:00 PM# And #6:00 PM#
        'afternoon
...and so on
End Select
Hope it helps...
 

Users who are viewing this thread

Top Bottom