>Does anyone know an easy way to tell if a DateTime value is Am/PM. I need the option when using the report form to print command to limit the records sent to print for either AM or PM based on user choice.
>
>Thanks
>Kirk
Try
RIGHT(CONVERT( varchar(32), DateTimeField,109),2) = 'AM'
--sb--