Nest "Previous" function

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
Smzemke_(Guest)
Posts: 41
Joined: Tue Oct 10, 2017 12:44 pm

Nest "Previous" function

Post by Smzemke_(Guest) » Thu Jun 23, 2005 12:35 pm

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!____ __

Rick_W_Johnson_(Guest)
Posts: 22
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: Nest

Post by Rick_W_Johnson_(Guest) » Thu Jun 23, 2005 12:51 pm

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.

Post Reply