>I need to see if swipetime in my table is greater than 12:00PM..
>
>I'm getting my data from an MS Access table.. it has the timeentry as DATETIME()..
>
>I made use of TTOD and TTOC to get date and time separetely and save them in two different fields.. into a foxpro table..
>
>Now I get the time as Character with entries such as 11:51:37 AM.. 02:30:57 PM.. etc..
>
>I don't know now how to compare this time.. to say.. > 12:00 or 13:00..
>
>Any help? TIA.
Leave it as Datetime and use the Hour() function. Also check SET HOURS TO to control between 12 Hrs and 24 Hrs format.
Luis
I never forget a face, but in your case I will make an exception :-)