Nest "Previous" function
-
- Posts: 41
- Joined: Tue Oct 10, 2017 12:44 pm
Nest "Previous" function
Is there any way to nest the "Previous" function?____I have a situation where I need to print a report that has:____ 1.Current Month (June)__ 2.Previous Month (May)__ 3. 2 Previous Months (April)____The field "month" will return the current month. I was able to setup PREV(month) to print "May". But, I can^t figure out to get April.____Any help would be greatly appreciated.____Thanks!____ __
-
- Posts: 22
- Joined: Tue Oct 10, 2017 12:44 pm
=> RE: Nest
I have a program that does this. I think PREV(PREV(Month))will work. if that does not work, I made date1= PREV(month), then date2 = PREV(date1). I know this works.