artsapimp — Wed, 20 Mar 2002 18:02:00 +0000

I think that's going to do it. I have to change the formatting a little so it will do a between statement for each result instead of one day but I think I can handle that. Thank you.

Peter J. Boettcher — Wed, 20 Mar 2002 16:42:03 +0000

Sorry about that, try this:

IIf(Day(Now()) > 27, Month(Now()) & "/27/" & Year(Now()), Month(DateAdd("m",-1,Now())) & "/27/" & Year(Now()))

I don't have a lot of experience using functions in Access but that should work.

artsapimp — Tue, 19 Mar 2002 21:24:25 +0000

Thank you.

I know that is the correct way to do it in ASP but I have to have this date manipulation done in access before bringing into the ASP application.

Do you know how I would write this in Access? I can't set variables in Access or I would follow the same basic idea you suggested.

Thanks for any help.

Peter J. Boettcher — Tue, 19 Mar 2002 17:03:59 +0000

I'm not sure exactly what you need but this will give you the right starting date, if you need the end date then just add one more variable to hold it.

strCurrentMonth = Now()
strPreviousMonth = DateAdd("m",-1,strCurrentMonth)
	
If Day(strCurrentMonth) > 27 Then
     strUseMonth = Month(strCurrentMonth) & "/27/" & Year(strCurrentMonth)
Else 
     strUseMonth = Month(strPreviousMonth) & "/27/" & Year(strPreviousMonth)
End If