>You are confusing a value returned by datetime() function with what is dispalyed
>
>>
>>I agree with Naomi, the Helpfile says explicit the value returned by DATETIME( ) is determined by the current SET HOURS setting. More important how can I get a 12 hour notation or am I forced to make a function?
>>
The Help file is confusing:
Use SET HOURS TO without 12 or 24 to return to the default 12-hour format.
TIME( ) always returns a value in 24-hour format and isn't affected by SET HOURS. The value returned by DATETIME( ) is determined by the current SET HOURS setting.
SET HOURS is scoped to the current data session.
----------------------------------------------------------------------------
In my tests I got the same output for ? DATETIME() regardless on the current SET HOURS settings.
If it's not broken, fix it until it is.
My Blog