Solved

CRecordSet m_strFilter <, > ???

Posted on 1998-05-12
2
433 Views
Last Modified: 2013-11-20
It is possible to Filter records between certain dates with the m_strFile, if so, how? if not, how?
0
Comment
Question by:lucidity
2 Comments
 
LVL 4

Accepted Solution

by:
piano_boxer earned 20 total points
ID: 1310091
Say you have a date/time field called time you would filter records the following way:

CMySet set;
set.m_strFilter = "(time >= #8/21/1997#) AND (time < #8/27/1997#)";
set.Open();
....

It will return all records from 8/21/1997 to and including 8/26/1997.
0
 
LVL 2

Author Comment

by:lucidity
ID: 1310092
A milllion thanks my friend
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Introduction: Load and Save to file, Document-View interaction inside the SDI. Continuing from the second article about sudoku.   Open the project in visual studio. From the class view select CSudokuDoc and double click to open the header …
Introduction: Ownerdraw of the grid button.  A singleton class implentation and usage. Continuing from the fifth article about sudoku.   Open the project in visual studio. Go to the class view – CGridButton should be visible as a class.  R…
This video will show you how to get GIT to work in Eclipse.   It will walk you through how to install the EGit plugin in eclipse and how to checkout an existing repository.
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

708 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now