Converting a variable name to Month number

[zagzebski]

I have a variable (vMonthNum) that I access through an input box. I have a constraint on it to show listed values referencing a Month field (Jan, Feb, Mar, etc)

I want to convert the selection the user makes (Jan, Feb, Mar, etc) to a number that corresponds to the month. So if from the drop down the user selects Mar I need it converted to 3. Looking for the expression to do this.

Thanks in advance,

Steve

[sunny_talwar · Accepted solution]

Try this:

vVar2 = Num(Date#(vVar1, 'MMM'))

vVar2 = Num(Month(Date#(vVar1, 'MMM')))

where vVar1 is linked to your inputbox

HTH

Best,

Sunny

[sunny_talwar]

Attaching a sample:

[zagzebski]

Thank so much!

[sunny_talwar]

No problem

I am glad I was able to help.

Best,

Sunny