InfoPath Dev

Hi,

 I have a drop down menu which users choose the current month from. 

How can I make the current month display in the drop down automatically?

 Thanks.

If you have a database you could use a table or create a simple XML to use as a secondary datasource.

Two columns

Number  Name

01             January

02             February

Etc...

Then in Open Rules parse the date. Since the date is yyyy-mm-dd we need to get just the month from the string and then use it to look up the correct value from the secondary data source list. 

Set your drop down to Name[number = substring-before(substring-after(today(), "-"), "-")]

Thanks for that Clay,

But I'm currently not using a DB table so how would I be able to do this using a drop down list.

Would it be possible for me to create a drop down list and then set it's value to show just the month part of the date by doing something like:-

 substring today(), 6, 2

The above doesn't work but I think it might just need tweaking a bit.

Thanks.

I think you could do this.

Add manual entries in your drop down. Make the value a number and the display the name of the month.

Then you could use a rule to set the field value to substring(today(),6,2) You need to build it in the formula window as today() does not copy.

That should do it.