>>>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.
>
>Hrm... I wonder if there's a setting somewhere that tells VFP to use the locale settings instead of the VFP-specific settings?
>
>One thing that I've noticed in the help file -- much of it assumes locale is the USA.
By later experiments I found that if I have SET DATE LONG or SET DATE SHORT or SET DATE DMY / MDY / YMD
then the SET HOURS settings are ignored. If I use SET DATE USA (or any other setting), then SET HOURS are respected by the displayed value.
If it's not broken, fix it until it is.
My Blog