current month?

[celauritz]

I have a report with the following fields:

event.eventdate
event.duedate
event.modifydate

Basically, the person is given an assignment on the event date, and they have seven days to modify the event. Due date is basically eventdate + 7.

The problem I am having is just in the record selection field. I have been using duedate in MonthToDate, but that is only showing things due up to and including today. I need to see events given yesterday that may be due six days from now, but keep it in the current month. (i.e. duedate in minimum(monthtodate) to maximum(monthtodate)+7 will not work because at the end of the month, I will just have to change the formula back to month to date)

 

[jdemmi]

I am a little confused about your exact goal. But if you're trying to restrict the query to items with a duedate within the next 7 days can't you say "

duedate >= today and
duedate <= DateAdd ("d",7,{event.duedate})




-- Jason
"It's Just Ones and Zeros

 

[celauritz]

I'm attempting to restrict my query to anything that is due in the current month. At this point, I am using:

duedate in monthtodate

This works, but, for instance, since this is the 13th of the month, there are some events that have not come due yet, but are in the current month.

I am getting everything that is due up to and including today, but there are other events due later in this current month.

 

[jdemmi]

I hijacked this from Ken before...


so instead of taking the credit....(search on this page for "Formula for the first and last day of a month")

http://www.kenhamady.com/news0508.shtml

-- Jason
"It's Just Ones and Zeros