>When I insert a DATETIME() into a record, I don't want it to put in the seconds. I have SET SECONDS OFF, but it still records the seconds. How can I make it just leave the seconds at 0?
>
>Thanks,
>
>Michelle
I'm afraid the DateTime format includes the seconds. Using "set seconds" you can prevent seconds from being displayed but the field with still contains the seconds value. To set the seconds value to zero you will have to use the DateTime function and pass the date and time values with seconds set to zero.
Sorry, I know of no other way to zero out the seconds.
Michael McLain