Can I break iContact date fields into day and month?

  • Profile Image
    trakwebster
    Asked on January 05, 2016 at 06:02 PM

    OK, I do have a follow up question.

    When I tried to export your Birthday datetime class of field to iContact with an iContact custom date field, the program crashed, but when I changed the iContact custom field to text, then it works.

    A date (in jotform) of 4/7/1944 arrives in iContact as "04 07 1944".

    In a few months I will want to send emails to people who have certain birthdays.

    However, I contact cannot sort by a custom field, and iContact cannot select very well. I can search for "04*" and get all those that start with "04" but that's about it, and the display does not let me break it down any further. 

    It would be far more useful if I could send them a "birthdayMONTH" field, and then a "birthdayDAY" field, and have these be different custom fields in iContact.

    Is there a way to do that?

  • Profile Image
    Jeanette
    Answered on January 05, 2016 at 09:56 PM

    I think that possible if you use Text fields, the information would be in different columns in your report though, not sure if that would be feasible and functional for your purposes.

  • Profile Image
    trakwebster
    Answered on January 05, 2016 at 10:53 PM

    Yup, Jeanette.

    I tried it and it works. Used dropdowns, and specified the choices. For months, used 01 January, 02 February, etc. For days, used 1-31. (Using the pre-defined "months" doesn't play nice.)

    On the iContact side, created simple text custom fields.

    This enables a field in iContact which will contain precisely what we want for selection purposes, as you know exactly how to match, as the form-user had no ability to format different than the dropdown choices. So in iContact you can select all the "01 January" people, for example.

    Because the day of month is in a separate field so as not to interfere with the matching of this selection. 

    And because we do have both month and day, we can send out emails which have tokens so as to spell out their upcoming birthday.

    Works a treat.

    Thanks.

  • Profile Image
    jonathan
    Answered on January 06, 2016 at 05:49 AM

    Thank you very much for taking the time providing us with such details. We really appreciate it.

    And we are glad to know it all work out for you. :)

    Don't hesitate to Contact Us anytime for any assistance you need.

    Cheers