Results 1 to 2 of 2

Thread: web to lead form - calendar date parsing for UK

  1. #1
    scorecomms is offline Sugar Community Member
    Join Date
    Jan 2010
    Posts
    23

    Smile web to lead form - calendar date parsing for UK

    Hiya

    I have a web to lead form on a website of mine where a user can choose a date for an event. However, the jscalendar parses the date as USA format: month/day/year whereas I am from the UK

    Code:
    <input onblur="parseDate(this, '%m/%d/%Y');" class="field3" name="bookingdate_c" size="12" maxlength="10" id="bookingdate_c" value="">
    <img src="sugarcrm/themes/default/images/jscalendar.gif?c=1" src="sugarcrm/themes/default/images/jscalendar.gif?c=1" alt="Enter Date" id="bookingdate_c_trigger" align="absmiddle">
    <script type="text/javascript"><!--
    Calendar.setup ({
        inputField : "bookingdate_c", ifFormat : "%m/%d/%Y", showsTime : false, button : "bookingdate_c_trigger", singleClick : true, step : 1, weekNumbers:false
    });
    // --></script>
    I've tried to change the %m/%d/%Y to %d/%m/%Y in both instances above but sugar won't save this correctly to the database, instead saving it as 00.00.00 and therefore an empty record.

    Could anyone help me? Any help will be greatly appreciated. Thanks!

  2. #2
    AlexAv's Avatar
    AlexAv is offline Sugar Community Member
    Join Date
    Oct 2009
    Location
    Ukraine
    Posts
    922

    Default Re: web to lead form - calendar date parsing for UK

    Hi,

    Do you whant to change this format or you whant to recieve current calendar format?
    Letrium ltd. - Only high quality service
    http://letrium.com

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Date Format for Web to Lead Form
    By Marketing2 in forum Help
    Replies: 5
    Last Post: 2009-06-09, 02:19 PM
  2. How to submit 'Web Form' as lead source from web form
    By pkelly08 in forum Developer Tutorials
    Replies: 0
    Last Post: 2008-10-07, 01:40 AM
  3. Replies: 0
    Last Post: 2008-10-07, 12:50 AM
  4. Replies: 0
    Last Post: 2008-05-19, 06:15 AM
  5. Replies: 6
    Last Post: 2006-10-02, 09:49 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •