What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    comparison of JotForm date to database date

    Asked by milbra on July 24, 2014 at 11:26 PM

    Form 1:  populates our database by manually copying and pasting info from an email into JotForm
    Form 2:  asks user for a start and end dates using Date/Time

    We want to use php to select all information from the database that falls between dates entered by the user. The date pasted in the 1st form uses "Jul" for the month, while the Date/Time in JotForm uses "07". Is there a way to change the users Date/Time format to "Jul"?

     

    format select form uses
  • Profile Image
    JotForm Support

    Answered by Welvin on July 25, 2014 at 06:15 AM

    Hi,

    Unfortunately, that is not possible in the DateTime field. How using our BirthDate field?

    This should give you the full name of the month rather than a number. Otherwise, I would advise to add a script in your PHP  codes to match dates when it's submitted as a number. 

    Thanks