Data Format

Data Format

I am in the process of moving from MailChimp to Zoho Campaigns for our email campaigns. I recently sent out a campaign that used a merge field that pulled through a date from a date field in Zoho CRM. The email was to tell customers that their subscription was to expire on the 1st August 2016.

In Zoho CRM the date field follows the UK format DD/MM/YYYY. However, we have had very confused customers asking why they have received an email telling them their subscription expires on 8th January. 

The merge field has reverted to US format MM/DD/YYYY so instead of showing the date as 01/08/2016 it has instead shown 08/01/2016. 

Is this a problem with my settings (I can't find a date format in the settings) or is it an issue with Zoho Campaigns automatically overriding the format of Zoho CRM no matter what?

Also, is there a way of previewing how merge fields will look before you send out a campaign? MailChimp allows you to live preview merge fields based on contacts in the mailing list. This means that problems like this can be seen before you mail your entire list.  

    Access your files securely from anywhere

        Zoho Developer Community




                                  Zoho Desk Resources

                                  • Desk Community Learning Series


                                  • Digest


                                  • Functions


                                  • Meetups


                                  • Kbase


                                  • Resources


                                  • Glossary


                                  • Desk Marketplace


                                  • MVP Corner


                                  • Word of the Day



                                      Zoho Marketing Automation
                                              • Sticky Posts

                                              • Marketer's space - Understanding portal roles in the new user management system

                                                Hello, As part of our new user management setup, we recently introduced portals and workspaces. Portals enable you to manage multiple products under a single brand within a single account. Workspaces are the spaces you can create within a portal for individual
                                              • Promote Campaigns on your LinkedIn Company page

                                                Hello!   We are happy to announce that Zoho Campaigns has further improved its integration with LinkedIn to provide more services. This time, we've come up with a new feature where you can promote your email and social campaigns on your LinkedIn company page.   LinkedIn company page is a hub where followers are updated about the company, its products & services and of course new features & updates. It acts as a public portal for prospects, vendors and partners, etc. You can engage your followers
                                              • The much-awaited real-time sync between Zoho Campaigns and Zoho CRM is live.

                                                Hello all, You don't have to wait for 24 hours to pull data from CRM to Campaigns anymore. Instantly bring subscriber data from contacts, leads, and custom modules and get going with your nurturing process right away.  What has changed?  We have two types of syncs now: Immediate and periodic.  The UI: We have cut down on the number of steps for the sync from three to two.  When to use which sync: Immediate Sync: When you want the data to get reflected in Campaigns as and when it is added in CRM.
                                              • Marketer's Space: Template Editor - Dynamic Content

                                                Dynamic content has become an inevitable part of email marketing. It's basically the process of displaying content to your leads that is relevant to them based upon them matching a particular criteria you have set previously.    To put it in simpler terms, it is the right content for the right people at the right time.    How to use the dynamic content While creating an email campaign, you go on to select a pre-designed or basic template to add content, and then click Advanced --> Dynamic to create
                                              • Sending Autoresponders to Existing Contacts

                                                Hello! In recent times, many of our users wanted to send Autoresponders to existing contacts. Since, these contacts existed already; they will never be receiving that message scheduled in the Autoresponders.  But, is there really a way to push these Autoresponder message(s) to such existing contacts? Well, Zoho Campaigns has again come up with a solution for such request laid by many of our users. We are happy to announce the new enhancement on Autoresponders through which you can send the Autoresponder


                                              Manage your brands on social media



                                                    Zoho TeamInbox Resources

                                                      Zoho DataPrep Resources



                                                        Zoho CRM Plus Resources

                                                          Zoho Books Resources


                                                            Zoho Subscriptions Resources

                                                              Zoho Projects Resources


                                                                Zoho Sprints Resources


                                                                  Qntrl Resources


                                                                    Zoho Creator Resources



                                                                        Zoho Campaigns Resources


                                                                          Zoho CRM Resources

                                                                          • CRM Community Learning Series

                                                                            CRM Community Learning Series


                                                                          • Kaizen

                                                                            Kaizen

                                                                          • Functions

                                                                            Functions

                                                                          • Meetups

                                                                            Meetups

                                                                          • Kbase

                                                                            Kbase

                                                                          • Resources

                                                                            Resources

                                                                          • Digest

                                                                            Digest

                                                                          • CRM Marketplace

                                                                            CRM Marketplace

                                                                          • MVP Corner

                                                                            MVP Corner





                                                                              Design. Discuss. Deliver.

                                                                              Create visually engaging stories with Zoho Show.

                                                                              Get Started Now