Hello all,
I'm trying to create a calculated column in a Calculation View that will determine a field's value based on the current month. If it is currently January, then the value would equal 0, February would equal 1, March would equal 2, and so on. I've tried a few different ways to do this, but haven't been successful.
There isn't a datedim table I can join to this table due to uncontrollable factors, so I'm currently using another Calculated column, CurrentDate, created using the formula:
date(now())
Anyone have any suggestions? This is my current formula
IF((leftstr("CurrentMonth",3) = 'Jan'),'000', <br>IF((leftstr("CurrentMonth",3) = 'Feb'),'001',
IF((leftstr("CurrentMonth",3) = 'Mar'),'002',<br><br>IF((leftstr("CurrentMonth",3) = 'Apr'),'003',
<br>IF((leftstr("CurrentMonth",3) = 'May'),'004',<br>IF((leftstr("CurrentMonth",3) = 'Jun'),'005',
<br>IF((leftstr("CurrentMonth",3) = 'Jul'),'006',<br>IF((leftstr("CurrentMonth",3) = 'Aug'),'007',
<br>IF((leftstr("CurrenMonth",3) = 'Sep'),'008',<br>IF((leftstr("CurrentMonth",3) = 'Oct'),'009',
<br>IF((leftstr("CurrentMonth",3) = 'Nov'),'010',<br>IF((leftstr("CurrentMonth",3) = 'Dec'),'011','000'))))))))))))
I've also tried a case statement, using rightstr(leftstr(date(now()),7,2) instead of the CurrentVersion, and leftstr(daydate(now()),3) as well.