>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
All men by nature desire knowledge.
Aristotle (384 BC - 322 BC), Metaphysics