Looking for current month sales and late orders

[steverdan]

I am trying to get sales totals available for this month and any previous late orders. I can manually enter the date, but is there a way to do <= current month?

[DellSC · Accepted solution]

You can create a formula that will give you the last day of the current month based on the current date. It would look something like this:

{@EOM}
DateAdd('m', 1, Date(Year(CurrentDate), Month(CurrentDate), 1)) - 1

Since this formula doesn't use any data, you can use it in the formula in the Select Expert without a performance hit. You would manually edit the formula to include this with any other selection criteria you've set up:

{MyTable.DateField} <= {@EOM} 

-Dell