supress seconds for datetime

  • Thread starter Thread starter iccsi
  • Start date Start date
I

iccsi

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,
 
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,
Click to expand...

If it's just a question of 'displaying' the seconds as :00 you can set
the form's date control's format property to:
hh:nn:"00"

The seconds will still be stored in the field, you just won't see
them.
 
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,
Click to expand...

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.
 
Back
Top