Controls

Re: How to display the current month

Clay Fox — Wed, 09 Jan 2008 16:34:17 GMT

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.

Re: How to display the current month

Zeetec — Wed, 09 Jan 2008 16:04:26 GMT

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.

Re: How to display the current month

Clay Fox — Wed, 09 Jan 2008 14:40:53 GMT

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(), "-"), "-")]

How to display the current month

Zeetec — Wed, 09 Jan 2008 11:37:35 GMT

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.