default value of yyyy.mm

[tagteam]

I am trying to create a default value in a field. The field is a combo box that pulls all the values from a lookup table I created. The table has values for year and month listed as yyyy.mm , so 2015.11 and then 2015.12



I have an unbound box on the form and have used the following formula =Cdbl(YEAR(TODAY())&"."&MONTH(TODAY()))

However, it says #name and does not show 2015.11 as the default value

[pbaldy]

Try the Date() function instead of Today().

[tagteam]

Yes, that fixed it, thanks

[pbaldy]

Happy to help.

[June7]

One problem with that expression. November (2015.11) will sort before February (2015.2). Need placeholder 0, like: 2015.02

Format(Date(),"yyyy.mm")

This will also eliminate the concatenation.

Probably should fix values in the lookup table. An alternative to the lookup table is to build the combobox list from data records.