You need to sign in to do that
Don't have an account?
dmcguffin
Three picklists to make a date field
I have a Month, Day and a Year picklist that I would like to create a single date field from, but I am confused on how to do that. Initially I thought it would be a text field with a formula attached to it, but that went south real fast. Any ideas would be greatly appreciated.
Issue is that your using picklist so you're going to have to use either ISPICKVAL or CASE function to generate the date. Not sure if this will work.
Date(Case(field,"2009",2009,"2008",2008,NULL),Case(field,"1",1,"2,",2,NULL),Case(field,"1",1,"2",2,....,"31",31",Null))