cancel
Showing results for 
Search instead for 
Did you mean: 

Looking for current month sales and late orders

steverdan
Participant
0 Kudos
114

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?

Accepted Solutions (1)

Accepted Solutions (1)

DellSC
Active Contributor
0 Kudos

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

Answers (0)