comparison of JotForm date to database date

  • milbra
    Asked 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"?

     

  • Welvin Support Team Lead
    Replied on July 25, 2014 at 6:15 AM

    Hi,

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

    comparison of JotForm date to database date Image 1 Screenshot 20

    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