On Open with Select in Field

[tim_at_ford]

Hey everyone!

I've got this Select in Field condition as such:

And this work fine when it comes Month but I want to add on the year as well for my MonthYear selection:

='=Year=year(today())'

Essentially I want to do this:

='=Month=month(today())'  plus ='=Year=year(today())'

So my "MonthYear" field will be populated correctly.  The on open search is working correctly for each.  I just want to combine them.

It's a syntax question and sorry for the elementary nature!!

[sunny_talwar · Accepted solution]

May be do it on the MonthYear field? or do it with two select in field actions?

[dplr-rn]

this is what has worked for me before

date(monthstart(today()), 'MMM-YYYY') - to set current month

but this assumes your year month is in date format.

whats the format of your year month field?

[tim_at_ford]

Sunny!!

OH YEA BABY, BABY!!

That worked!!!  Thank you sir!!

[tim_at_ford]

Thank you for your reply Dilipranjith we got it working!!