Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Useful code to identify weekend dates in a file

Posted on 2003-10-23
7
Medium Priority
?
244 Views
Last Modified: 2010-04-17
I want to find a block of code or some sort of plug-in to assist me with pulling out all records that contain a weekend date in the dateField column.
0
Comment
Question by:peacockcl
  • 3
4 Comments
 
LVL 9

Expert Comment

by:malharone
ID: 9609360
what's the db vendor? access/sql server? or are you doing this programmatically. .. if so, then what's langauge?
0
 

Author Comment

by:peacockcl
ID: 9609393
I'm using ACL, much like access/sql server but not quite as powerful or easy to use.  I was wondering if there was anything out there that I could adapt to work with my program.
0
 
LVL 9

Accepted Solution

by:
malharone earned 500 total points
ID: 9609455
in ms sql server, use DATENAME(dw,YOUR_DATE_FIELD) e.g. SELECT DATENAME(dr, getdate())  
  -- this function in your sql statement returns the day of the week (Sunday, Monday, and so on). so you can set a where condition to exclude/include rows.


in msaccess
SELECT Table1.dt
FROM Table1
WHERE (((Format([dt],"dddd"))="sunday")) OR (((Format([dt],"dddd"))="saturday"));
0
 
LVL 9

Expert Comment

by:malharone
ID: 9609648
i'm not familiar with ACL. if it is db system, then i'm sure they provide date/time calculation functionality.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Computer science students often experience many of the same frustrations when going through their engineering courses. This article presents seven tips I found useful when completing a bachelors and masters degree in computing which I believe may he…
Make the most of your online learning experience.
Simple Linear Regression
Starting up a Project

783 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question