by: sheilasabado April 14, 2010 3:36 AM PDT
0 people like this thread
Staff pick
Total posts: 6 (Showing page 1 of 1)
Re: selection
by Kees Bakker 
- 4/15/10 12:30 AM
In Reply to: MS Access - Date()-1 and Time Between 8:00am and 9:30PM by sheilasabado
It's not really important where the data comes from. It's important how it's stored in the database. Is it one field with Date/Time format? Or 2 with text format? Or ...?
And can you tell what your difficulty is? What did you try and didn't work yet?
Kees
re: selection
by sheilasabado - 4/18/10 3:03 AM
In Reply to: Re: selection by Kees Bakker
Hi Kees, thanks for the reply.
1. Date/Time format - General Date
2. I have tried putting:
>Date()-1 and Between #8:00:00 AM# and #9:30:00 PM#
But it won't work. I hope you can help me with this.
Re: selection on date time
by Kees Bakker - 4/18/10 3:34 AM
In Reply to: re: selection by sheilasabado
To select all fields from Table1 with the selection you specified based on field dt in that table I used the following SQL-statement (that's another word for a query).
SELECT *
FROM Tabel1
WHERE (((Format([dt],"yyyymmdd"))=Format(Now()-1,"yyyymmdd")) AND ((Format([dt],"hh:mm"))>="08:00" And (Format([dt],"hh:mm"))<="21:30"));
The trick, as you see, is to convert the relevant parts of the date to strings.
Kees
re: se
by sheilasabado - 4/18/10 4:17 AM
In Reply to: Re: selection on date time by Kees Bakker
Thank you so much Kees! It works! =)
(NT) You're welcome. Thanks for letting us know.
by Kees Bakker - 4/18/10 5:44 AM
In Reply to: re: se by sheilasabado
Total posts: 6 (Showing page 1 of 1)
Unread
Read
Locked thread
Moderator
CNET Staff
Samsung Staff
Norton Authorized Support Team
AVG Staff
avast! Staff
Webroot Support Team
Acer Customer Experience Team
Windows Outreach Team
Dell Staff
Intel Staff
Question
Resolved question
General discussion
Tip
Alert or warning
Praise
RantYou are e-mailing the following post: Post Subject
You are reporting the following post: Post Subject
You are posting a reply to: Post Subject
-1%20and%20Time%20Between%208:00am%20and%209:30PM%20-%20CNET%20Office%20%26amp;%20productivity%20software%20Forums&srcUrl=http://forums.cnet.com/ms-access-date-1-and-time-between-8-00am-and-9-30pm/7723-6129_102-390529.html?messageId%3D3288603&x_breadcrumb=6035:7572:6129){kind=small}
Manage updates with the Download App