Issue with default selection on Month using Bookmark

[punitpopli]

Hi Experts,

I am applying a dynamic selection on a Month Field using expression and bookmark

Exp that have used on the month filed to select latest month is - 

Num(Month(Today())))

and on the filed I have used  "=Month =Num(Month(Today()))"

This is setting up the latest month every time user access the application. Everything fine till here

Their are some column which will be displayed on the basis of month selection and when the app is open as have used calculated exp to select latest month the expressions are not getting enabled. As in GetfieldSelection of Month it returns the expression and not the value

Any help on this will be appreciated!

thanks in advance

[stevejoyce]

Yea that does seem odd it does that.

Can you just reuse the formula in your expression enable condition Num(Month(Today())) = whateveryouwant.

It looks like this maybe resolve the formula with some extra stuff so maybe you can do...

subfield('$(=getfieldselections(Month))', '=', 3)

[punitpopli · Accepted solution]

hi @stevejoyce 

I have derived the expression the same way, details on the same in below - 

vMonthDefault = SubField(SubField(GetFieldSelections(Month),'h=',2),'"',1)

Using this step I need to extract the exact formula to select latest month i.e. Num(Month(today()))

=IF(len(GetFieldSelections(Month,',',12)) <=26
,Chr(39) & GetFieldSelections(Month,Chr(39)&','&Chr(39),12) & Chr(39),Chr(39)&'$(=$(vMonthDefault))'&Chr(39) )

then using above formula I need to run extract the month value when its the default selection for rest of the timr it should just get the user selected months separated by a comma