month start giving wrong value

[arulsettu]

hi i am trying to get month from from month field

TBAL_Month ={">=$(=MonthStart(max(TBAL_Month)))<=$(=max(TBAL_Month))

result is

MonthStart(max(TBAL_Month)))=1/1/1900

but tabl_month contain jan feb mar .... dec

am i doing anything wrong here

plz give me some solutions

thanks

[prieper]

please upload an example to see, what kind of data you use

Peter

[arulsettu]

please check above in this thread i uploaded a sample

[prieper]

TBAL_Month is not a number, but only a text (abbreviation for the month).

Think it will make sense to work with rolling monthes:

YEAR(Date)*12 + NUM(MONTH(Date))

This might be accessed with MIN/MAX or you may calculate to deduct e.g. 6 monthes etc

HTH Peter