>Hi,
>
>I have a table that has a datetime field. The table contains numerous records.
>Is there a command or a function that I can use to convert all the seconds of the datetime fields to zero?
>
>example: 12/05/01 09:08:35 AM change to 12/05/01 09:08:00 AM
>
>any help will be greatly appreciated.
>
>Thanks in advance

Mike,

try to use this formula , may be this will help you

? datetime()-sec( datetime())

see you