I have an applcation using datetime until minutes. I need seconds
always zero.
I just wonder any function that can supress seconds?
Your information is great appreciated,
As Fred says, you can suppress the display of the seconds even if they're
stored.
If you want to actually update the data in the table so that (say) 11:56:28 is
actually stored as 11:56:00, you'll need to do some trickery. If it's a
date/time field containing an actual date and time, try an Update query
updating it to
Format([datetimefield], "\#yyyy-mm-dd hh:nn\#")
If it's a time only (actually a date/time on December 30, 1899) leave out the
yyyy-mm-dd portion.