Re: AM/PM Logical ? by Rush
Rush
Tue Apr 22 12:40:19 CDT 2008
Jonathan Morningstar wrote:
> Is there a way to test weather the time is AM or PM with a logical
> .T./.F. return?
>
> Respectfully,
>
> Jonathan Morningstar
If you want to test the weather, just stick your hand out the window -
this works morning or night. [Sorry.]
Since 12 noon is defined as 12 PM;
lIsAM = HOUR(Time|DateTime) < 12
should do it. HOUR() returns a 24 hour value, regardless of your local
display settings.
- Rush