General information
Category:
Coding, syntax & commands
>>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.
I figured it out. CTOT(TTOC(DATETIME)) with seconds off.
Thanks,
Michelle
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only