Birthday Month Smartlist

Anonymous
Not applicable

Birthday Month Smartlist

Can anyone assist with a smartlist to find each leads Birthday Month? 

e.g. if Janes' birthdate is 24 Sep 1975, i'd be able to run a smartlist showing Jane on Birthday Month = September.

3 REPLIES 3
Kim_Allen
Level 10

Re: Birthday Month Smartlist

Hi Chantelle,

This would depend on what fields you are using to capture the information. If you happen to have a birthday month field (maybe if this information is really important to your company) then you could pull the smart list just as you say, with the one filter. BUT most likely I'm guessing you just have a standard date of birth, date type, field. In that case your best bet would probably be an export of your database with that field as a column and just do the work to pull out the month and then put into a custom field and re-import for future use. Then you could add that new field to forms (if it's really important to know) OR put in place a formula in SFDC.

Kim

Anonymous
Not applicable

Re: Birthday Month Smartlist

Hi Kim,

No, we don't currently have a BirthMonth field.  That would make life easy.  As you say, we only have a DD/MM/YYYY field.

Your solution would be fine for the short-term, but any new leads added would have this information missing. Would prefer if there was some magic smartlist to 'figure out the month' based on the Date of Birth.

SanfordWhiteman
Level 10 - Community Moderator

Re: Birthday Month Smartlist

Chantelle, it's very easy to extract the month from a user-entered date field on a form.  So if you backfill your existing leads, you can make sure to populate new ones on the form level:

MktoForms2.whenReady(function(form){

form.onSubmit(function(form){

   form.setValues({

     BirthMonth: new Date(form.getValues().DateofBirth).getMonth()+1

   });

});

});