remove seconds from date_time field

[gdesreu]

I record the date and time I load records to the database. These times are critical for grouping data for our purposes, however when I load a large group of data, the seconds are also entered which nullifies the purpose of the field because the seconds make the field unique and when I query using distinct I get multiple times for a group of data instead of one. If I format the field to say mm/dd/yyy hh:nn...looks ok when you are looking at it but the seconds are still stored and returned when clicking in the field or running distincts. Is there any way to prevent the seconds from being stored? For example default field value is =now() and format is mm/dd/yyy hh:nn, seconds are still there I want them gone forever or better yet never entered in the first place.
Thanks

 

[james_lankford]

when you insert the date hard code the seconds to 00

so
6/14/2017 11:22:35 am
would be
6/14/2017 11:22:00 am

 

[gdesreu]

when you insert the date hard code the seconds to 00

so
6/14/2017 11:22:35 am
would be
6/14/2017 11:22:00 am

I would prefer the :00 not to be there but that would work. I just tried this:
default field value = Format(Now(),"mm/dd/yyyy hh:nn")
This seems to do what I want. (I think....will need further testing with real data)
Thanks

 

[james_lankford]

pretty sure that just sets the seconds to zero

I may be wrong though