springer01

Help needed for unusual MonthSort equation

Discussion created by springer01 on Aug 9, 2017
Latest reply on Aug 23, 2017 by philmodjunk

I have a VISA account in which  the accounting period is from the 5th of any Month thru the 4th of the succeeding Month.

I'd like to calculate the Month to be from the 5th of any Month thru the 4th of the succeeding Month, so it can be used in a MonthSort calculation. Field Name for the Date is d_date

I want that for comparison to my VISA statement so as to detect any data-entry errors on my part.

I've tried several equations with no success. Any help will be appreciated.

Outcomes