+ Start a Discussion
Michael Webb 5Michael Webb 5 

Need user to pick day and month not year such as 03/15 this is the date something occurs every year

Need user to pick day and month not year such as 03/15 this is the date something occurs every year. So this report needs to be filed every year on March 15th, do not want the year because it does not matter in any way what so ever, it would actual be a hinderance. I am not sure how to do this, can you do this?

Thanks in advance.
Best Answer chosen by Michael Webb 5
pconpcon
One solution to this would be to just have two fields (Month and Day) and then a formula field that combines them into the format that you want.

Another option would be to use the standard Date field that Salesforce provides and then using a formula strip the year from the end.  This might be a little confusing for your users if they see a year on the field, but it would be the simplest as far as UI goes.

All Answers

pconpcon
One solution to this would be to just have two fields (Month and Day) and then a formula field that combines them into the format that you want.

Another option would be to use the standard Date field that Salesforce provides and then using a formula strip the year from the end.  This might be a little confusing for your users if they see a year on the field, but it would be the simplest as far as UI goes.
This was selected as the best answer
PratikPratik (Salesforce Developers) 
Hi Michael,

+1

2 picklists one for months(1-12) and other for days (1-31) will be a good approach, then you can concatenate it in a formula.
Using standard dates will not allow you to drop the year value.

Thanks,
Pratik
Robert ZentgrafRobert Zentgraf
Hi Michael,

you can use the approach from Pratik. Additional, you should create a dependent picklist (e. g. February has only 28/29 days) or create a validation rule to receive possible dates.

Regards
Robert
(mindforce: mind-force.de)