I have 2 picklists with numbers, one for month one for and year. How do I convert this into a full date format (so we can properly report on that record)?
I have month field (picklist values 1-12) and year field (picklist values 2000-2050)
I want the date field output to be the first of whatever month is selected. (The Day isn't entered by the user).
I have this so far, which is passing the syntax check but returning an error:
DATE(
1,
VALUE(TEXT(Month__c)),
VALUE(TEXT(Year__c))
)
Thanks!
4 件の回答
