AnsweredAssumed Answered

Using Month in a calculation

Question asked by KevinSalisbury on Apr 21, 2012
Latest reply on Apr 27, 2012 by philmodjunk


Using Month in a calculation



There may be a simple answer to this, but I have a month field that is unrelated to an date within my layout. This value is used to "filter" and enter records related to this month (and year). I'm trying to create an "up" and "down" button that will move through the records accordingly. I have the up and down buttons set to "go to field" with a calculation "Month + 1" or "Month -1". The problem is that I'm not sure weather the Month field should be treated as a text, number, or date to make this work. I orginally had it as a text field that was based on a vlue list that I entered manually. Any suggestions?