UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Query Between Sundays And Mondays, Access 2013    
 
   
ry94080
post Jun 14 2019, 12:37 PM
Post#1



Posts: 1,005
Joined: 27-July 05



Hi all,

I'm trying to put together a query that will pull data for ALL Sundays from 10PM to Mondays to 06am.

I have a dataset that has the date field. I just don't know how to only pull data that are between those two time frames without putting in a specific date.

Is this possible?
Go to the top of the page
 
MadPiet
post Jun 14 2019, 12:49 PM
Post#2



Posts: 3,159
Joined: 27-February 09



You can use Weekday() to get the number of the day of the week. then you can check the times using HOUR()
Go to the top of the page
 
GroverParkGeorge
post Jun 14 2019, 02:26 PM
Post#3


UA Admin
Posts: 35,290
Joined: 20-June 02
From: Newcastle, WA


There's a demo on my website.

--------------------
My Real Name Is George. Grover Park Consulting is where I do business.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 
ry94080
post Jun 14 2019, 03:33 PM
Post#4



Posts: 1,005
Joined: 27-July 05



perfect, thanks
Go to the top of the page
 
GroverParkGeorge
post Jun 14 2019, 05:17 PM
Post#5


UA Admin
Posts: 35,290
Joined: 20-June 02
From: Newcastle, WA


Pieter and I are happy to help.

Continued success with your project.

--------------------
My Real Name Is George. Grover Park Consulting is where I do business.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    16th July 2019 - 01:15 AM