Field in Form shows "good am" "good afternoon" "good evening" 1

[lmcate]

I have a form and I have a calculated field to show the respect time of the day, but it only shows "good morning" even if it is 5:00p.m.m.

Here is my calculated field

TIEMPO: IIf(Now()>TimeValue("12:00:00"),"Good Morning",IIf(Now()<TimeValue("18:00:00"),"Good Afternoon","Good Evening"))

Any help will be appreciated.

Sam

 

[Andrzejek]

Looks like fun homework....

[tt]TIEMPO: IIf(Time > TimeValue("18:00:00"), "Good evening", IIf(Time > TimeValue("12:00:00"), "Good Afternoon", "Good Morning"))[/tt]

Have fun.

---- Andy

There is a great need for a sarcasm font.

 

[lmcate]

THANK YOU!!! Andy... This work by substituting time() instead of time.