Returning this months and next months records

[Slab_Rankle]

Hey,

This is probably a really simple question but I can't seem to find the answer anywhere! I have a query that shows when a client needs to be distributed (DistribStart). I want to display all records due to be distributed this month and also next month. How do I do this? Help would be greatly appreciated!

 

[Taruz]

Hi..

only to records this month, can use this criterion..:

between dateserial(year(date()),month(date()),0)+1 and dateserial(year(date()),month(date())+1,0)


records only for the next month, can use this criterion..:

between dateserial(year(date()),month(date())+1,0)+1 and dateserial(year(date()),month(date())+2,0)

For the two-month registration list, use it..:

between dateserial(year(date()),month(date()),0)+1 and dateserial(year(date()),month(date())+2,0)

I hope, you are suitable purpose..