By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,225 Members | 1,434 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,225 IT Pros & Developers. It's quick & easy.

date in reports

P: n/a
hi,
how can i set the dates in a fieldn in my tables in ms access to
handle only dates and no time? in creating my table, i set its type
to 'date/time' with 'short date' format. but when i entered values in
it, the data i get was '4/1/2004 4:28:12 PM'. i only want this field
to hold date and no time. can somebody tell me how to get rid of the
time?
thanks!
nick_faye
Nov 13 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
On your data entry form, you are using Now() to enter the date. Now() also
includes the time. Change Now() to Date().

Make a copy of your table and try this to change your existing data to date
only. Change the data type of the field to Integer. This should drop the decimal
portion of the data values which is the time. Then change the data type back to
date/time.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"nick_faye" <iv******@yahoo.com> wrote in message
news:8a**************************@posting.google.c om...
hi,
how can i set the dates in a fieldn in my tables in ms access to
handle only dates and no time? in creating my table, i set its type
to 'date/time' with 'short date' format. but when i entered values in
it, the data i get was '4/1/2004 4:28:12 PM'. i only want this field
to hold date and no time. can somebody tell me how to get rid of the
time?
thanks!
nick_faye

Nov 13 '05 #2

P: n/a
nick_faye wrote:
hi,
how can i set the dates in a fieldn in my tables in ms access to
handle only dates and no time? in creating my table, i set its type
to 'date/time' with 'short date' format. but when i entered values in
it, the data i get was '4/1/2004 4:28:12 PM'. i only want this field
to hold date and no time. can somebody tell me how to get rid of the
time?
thanks!
nick_faye


Format your output on your report as a date only :)
--
regards,

Bradley
Nov 13 '05 #3

P: n/a
thanks for the inputs...

actually, i just found out that my real problem is in my query because
when i want to group my entries according to dates, my query cannot
group them because it seems that it is also evaluating the time... so
if i have entries with '4/1/2004 4:28:12 PM' and '4/1/2004 4:30:12
PM', my query treat them as two separate dates because they have
different time... any ideas how to eliminate my problem? please
help...

"Bradley" <br*****@REMOVETHIScomcen.com.au> wrote in message news:<Vz****************@news-server.bigpond.net.au>...
nick_faye wrote:
hi,
how can i set the dates in a fieldn in my tables in ms access to
handle only dates and no time? in creating my table, i set its type
to 'date/time' with 'short date' format. but when i entered values in
it, the data i get was '4/1/2004 4:28:12 PM'. i only want this field
to hold date and no time. can somebody tell me how to get rid of the
time?
thanks!
nick_faye


Format your output on your report as a date only :)

Nov 13 '05 #4

P: n/a
iv******@yahoo.com (nick_faye) wrote in
news:8a**************************@posting.google.c om:
thanks for the inputs...

actually, i just found out that my real problem is in my query
because when i want to group my entries according to dates, my
query cannot group them because it seems that it is also
evaluating the time... so if i have entries with '4/1/2004
4:28:12 PM' and '4/1/2004 4:30:12 PM', my query treat them as
two separate dates because they have different time... any
ideas how to eliminate my problem? please help...
I assume this is in a totals query.

Put the date in the query a second time.as an expression
expr1: format(mydate, "yyyymmdd") group on it, but make it
invisible. change the group By for the other date as First of,
and it should give the result you want.

Bob Quintal

"Bradley" <br*****@REMOVETHIScomcen.com.au> wrote in message
news:<Vz****************@news-server.bigpond.net.au>...
nick_faye wrote:
> hi,
> how can i set the dates in a fieldn in my tables in ms
> access to
> handle only dates and no time? in creating my table, i set
> its type to 'date/time' with 'short date' format. but when
> i entered values in it, the data i get was '4/1/2004
> 4:28:12 PM'. i only want this field to hold date and no
> time. can somebody tell me how to get rid of the time?
> thanks!
> nick_faye


Format your output on your report as a date only :)


Nov 13 '05 #5

P: n/a
nick_faye wrote:
thanks for the inputs...

actually, i just found out that my real problem is in my query because
when i want to group my entries according to dates, my query cannot
group them because it seems that it is also evaluating the time... so
if i have entries with '4/1/2004 4:28:12 PM' and '4/1/2004 4:30:12
PM', my query treat them as two separate dates because they have
different time... any ideas how to eliminate my problem? please
help...
Easy, sort on a formatted date in your query.

"Bradley" <br*****@REMOVETHIScomcen.com.au> wrote in message
news:<Vz****************@news-server.bigpond.net.au>...
nick_faye wrote:
hi,
how can i set the dates in a fieldn in my tables in ms access to
handle only dates and no time? in creating my table, i set its type
to 'date/time' with 'short date' format. but when i entered values
in it, the data i get was '4/1/2004 4:28:12 PM'. i only want this
field to hold date and no time. can somebody tell me how to get
rid of the time?
thanks!
nick_faye


Format your output on your report as a date only :)


--
regards,

Bradley
Nov 13 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.