Page 1 of 1

Nest "Previous" function

Posted: Thu Jun 23, 2005 12:35 pm
by Smzemke_(Guest)
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!____ __

=> RE: Nest

Posted: Thu Jun 23, 2005 12:51 pm
by Rick_W_Johnson_(Guest)
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.