comparison of JotForm date to database date

  • Profile Image
    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"?

     

  • Profile Image
    Welvin
    Answered 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