By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,987 Members | 997 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,987 IT Pros & Developers. It's quick & easy.

Query for records before paydays

P: n/a
I have a table of checking transactions. Some are past, some from
today, and some are dated with future dates (such as recurring
payments).
Is there a way to set up a query for my balance (credits minus debits)
that will exclude transactions that occur after upcoming paydays (1st
and 15th) dynamically? For instance, if I have a transaction scheduled
for the 2nd of next month (after payday on the 1st) I'd like to be able
to separate it dynamically/automatically from the transactions that are
coming out of this payday.
I have tried WHERE <=DateSerial(Year(Date()),Month(Date()),0)
but it only returns transactions up until this month.
Anyone know how to do this?
Thanks for your help.

Aug 18 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a

OK, I have found how to get it to return all transactions up to and
including the current month's:
WHERE datetransaction<=DateSerial(Year(Date()),Month(Dat e()),31);
where the 31 represents the date of the current month.

Also I see how to query for transactions after a certain date of the
current month, for instance this will return all transactions dated on
or after the 15th of the current month:
WHERE datetransaction>=DateSerial(Year(Date()),Month(Dat e()),15);

But now what I'm having trouble with is how to reference next month.

Aug 18 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.