question about a dual field

[Anonymous]

Hi,

Month is a dual field. I'd like to use it in a set expression.

{<Month={'TextValue'}>} - this script works fine

e.g. {<Month={'Январь'}>}

{<Month={NumericValue}>} - this doesn't work

e.g. {<Month={1}>}

I need to base my set expression in a numeric value of Month for some reason.

Is it possible?

Thank you in advance,

Larisa

[MK_QSL]

Create two field like below

Month(Date) as Month,

Num(Month(Date)) as MonthID

Now use MonthID in your set expression.

[sasiparupudi1]

try

{<Month={$(=Month(1))}>}

[Anonymous]

it results in null.

[prabhu0505]

Pls try.

{<Num(Month)={NumericValue}>}

[Anonymous]

I results in error

[sasiparupudi1 · Accepted solution]

is your month in the format like January,Febrauary,etc?

if yes then this should work

{<Month={"$(=Date(Month(1),'MMMM'))"}>}

[sasiparupudi1]

Hi

Sorry, I think the expression should be

date(makedate(year(today()),11),'MMMMM')

{<Month={"$(=date(makedate(year(today()),2),'MMMMM'))"}>}

hth

Sasi