Useful code to identify weekend dates in a file

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.
peacockclAsked:
Who is Participating?
 
malharoneConnect With a Mentor Commented:
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
 
malharoneCommented:
what's the db vendor? access/sql server? or are you doing this programmatically. .. if so, then what's langauge?
0
 
peacockclAuthor Commented:
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
 
malharoneCommented:
i'm not familiar with ACL. if it is db system, then i'm sure they provide date/time calculation functionality.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.