Getting the full date instead of the abbreviation in the calculation using DateString function

  • Profile Image
    davidgrayvideos
    Asked on February 04, 2017 at 08:45 AM

    Seeing as you have gone all posh and upgraded everything I wondered if you have ever thought about upgrading your date system. I would imagine that most forms, have at some point, got a date on them and I am disappointed to say the least that in the well promoted upgrade you have done nothing to modernise the date string. It still displays as Tue Oct 03 2017 . 

    Why is it too much to ask to have the date string read properly such as Tuesday, the 3rd of October, 2017. ?

    It infuriates me that no-one, not one single member of staff has cottoned on to the idea that people need proper dates wrote down for when dealing with professional customers. It does NOT look good when portraying a text slang date in a professional email. Come on guys get modern and upgrade the whole system not just what you think needs upgrading!

  • Profile Image
    Welvin
    Answered on February 04, 2017 at 10:57 AM

    Based on your form settings, I think you would only like to show this format by email. In this case, this is possible per Date Formatting feature.

    https://www.jotform.com/help/68-Add-a-Date-on-Email-Notification

    But to use this per your conditional output, you need to change your form structure. You can do it this way:

    1. Two date fields. The Wedding Date field and another date less than 90 days.

    2. To get the date minus 90 days, do it with conditional logic. Example, targeting the other date field:

    3. To get your desired date formatting, you can paste the tag like this:

    {dateMinus:l, \t\h\e jS \of F, Y}

     

    dateMinus is the name of the field. You can get this by following the steps here: https://www.jotform.com/help/146-How-to-find-Field-IDs-Names.

    The result:

    You can test this form: https://www.jotform.com/70344298797976. Enter your real email address. 

    As for the DateString in the calculation, I will forward the matter to our widget team for consideration.

    Let us know if you need further assistance.

  • Profile Image
    davidgrayvideos
    Answered on February 04, 2017 at 12:17 PM

    Doesn't work! Only returns a capital letter T in the date, so it is absolute rubbish. Why don't you just provide a proper date string in your builder like any normal business instead of having to mess about like this?

    The other method only returns today's date which is as much use as a chocolate fireguard!

  • Profile Image
    Welvin
    Answered on February 04, 2017 at 01:32 PM

    You get my autoresponder, right? What's wrong with the format, can you explain further? Here's a screenshot your submission in my form:

    You have also tested the formatting, I see it's correct. Here's a screenshot from your form:

     

    Well, this is just a workaround while this formatting is not yet available in the DateString function through calculation. I am sure this will work for you. If you want, we can format it in your form emails. Just please let us know your specifics, especially the arrangement of the day, date, month, and year. 

  • Profile Image
    StrawberryDesi
    Answered on February 04, 2017 at 05:13 PM

    I too, would like to see an option to display "Tues. Nov. 02, 2017" as "Tuesday, November 2, 2017".

     

    Thanks guys.

     

    Henry

  • Profile Image
    EltonCris
    Answered on February 05, 2017 at 01:45 AM

    @Henry

    We moved your question to a separate thread here https://www.jotform.com/answers/1056950. We'll be on it shortly.

  • Profile Image
    davidgrayvideos
    Answered on February 05, 2017 at 03:41 AM

    For crying out loud now it displays this;

    Firstly let us congratulate you on your forth coming marriage and wish you all the very best!

    Should you wish to proceed and book with us then the entire cost of your package is £400, which includes V.A.T. and all our features and expenses. A deposit of £50 will be required to secure the booking and the remaining £350 balance can be paid using our flexible payment methods. Pay off what you want, when you want, all at your convenience before 0, the 15th of November, 2016</00pam11></00pam11></00pam11><00pam11 003016TuesdayAmerica/New_York="f20161130-fam1100Tuesday16: amTue, 15 Nov 2016 00:00:00 -050000amTuesday, 12America/New_YorkTuesdayvAmerica/New_York30002016-11-15T00:00:00-05:00am, 00am1100-00America/New_YorkTue, 15 Nov 2016 00:00:00 -050000f; f20161130-0000319America/New_York: 14p30; 2016-11-15T00:00:00-05:002016Tuesday2016Tue, 15 Nov 2016 00:00:00 -0500: #000080;">.

     

    For now though, we need to check our database to see if your wedding for Mon Feb 13 2017 is available. We will let you know shortly by email to

  • Profile Image
    davidgrayvideos
    Answered on February 05, 2017 at 03:54 AM

    Now this is getting beyond a joke. I have copied and pasted the provided code into the email with the date placeholder as described.

    But still the stupid email autoresponder FAILS to do as you described. And yes I have tested your example from the previous response but you never provided the background set up to discover how it was acheived. You only provided a form to play with. I hate your new version you have wasted a lot money creating a monster which very little improvement on features and benefits. I will be reverting back to version 3 until I find an alternative. Also your customer has also deteriorated drastically with little knowledge and respect for the user.

  • Profile Image
    davidgrayvideos
    Answered on February 05, 2017 at 04:05 AM

    Can we please have someone other than Welvin to provide a decent reliable response. All the replies have been wrong, frustrating and time consuming!

    After all you do say that you are The Easiest Online Form Builder: which is a lie!

     

  • Profile Image
    EltonCris
    Answered on February 05, 2017 at 05:26 AM

    Sorry about that. I tried my colleague Welvin's suggestion and it worked for me. Actually, his solution is the only way around at least for now.

    I guess it has something to do with the text formatting (the way you copy and pasted the field name in the autoresponder template, the HTML formatting was also carried over which messed up the field name when sent over email). 

    I suggest copying the field name again and paste it as text by pressing Ctrl+Shift+V key in your keyboard. 

    {expectedDate:l, \t\h\e jS \of F, Y}

    It should look like the following afterward. As you can see, the text format of the field name automatically adapts the existing format.

    If you still can't get it to work, let us know so we can do it for you.

    ---

    With regards to the dateString function on form calculation, I have forwarded it as a feature request to our developers. As soon as they made changes to it, we'll let you know here.

    Regards