Welcome Screen

[foxtet]

the following code i obtained from a link given by Gina

="Good " & IIf(Hour(Time())<12,"Morning",IIf(Hour(Timer())<16,"Evening","Afternoon"))

it has problem displaying afternoon and evening ..even after 16 it displays afternoon..can there be any solution to resolve error

fox

 

[MarkK]

You have Time() and Timer(). Time() returns the system time. Timer() returns the number of seconds since midnight.

="Good " & IIf(Hour(Time())<12,"Morning",IIf(Hour(Timer())<16 ,"Evening","Afternoon"))