dateserial for BF?

[meyou]

Hey everyone,

I am looking around for a way to built a Bring Forward system for my access database.

I have a Modified Date field and each first of the Month I would like to print a report of records where the month of the field is the month from now() but year(now())-1.

Is that possible?

Sincerely,

 

[Brianwarnock]

Since you don't need the time use Date() not Now()
do you mean between
Dateserial(year(date())-1, month(date()),1)
and
Dateserial(year(date())-1, month(date())+1,0)



Brian

 

[meyou]

Ok,

That's interesting, I will use the Date() function then, I don't need the time.

Now, for the BF, the idea is to query the DB for all the records that will expires in 1 month. So if I run the query today, Access should return all the records where the modified date is in April 09. The day does not matter for me.

Any suggestions?

Sincerely,

 

[Brianwarnock]

So if the above was giving all March 2009 then I guess adding 1 to Month in the First and 2 to Month in the second will give you ????

Brian

 

[vbaInet]

Just a thought Brian, do you think the DateAdd() function would be sufficient for this?

 

[Brianwarnock]

How would you use that to vary both the year and the month and make the day the first and last of the month, if you get what I mean.
I must admit to being a Dateserial fan for this type of thing as you would find in the reference section when I reworked AJTrumpets formulae for time periods.
Dateserial is a doddle for this type of requirement.

Brian

 

[vbaInet]

I wasn't quite clear on what the OP wanted, I thought it was just subtracting a year from it

So yes, agreed with DateSerial()