[Plugin: Participants Database] Date problem

  • martinahawkins

    (@martinahawkins)


    13 years ago

    I am having a problem with the date of birth field
    – as a ‘date’ format database is blank
    – as a ‘text line’ then database is populated but anything can be entered.
    – as a ‘text line’ with regex expression works ok except it can’t be made mandatory too as you have to choose between yes,no,regex. Is that correct?
    I would like to use regex but also have date mandatory. Is this possible?
    Regex expression using:
    ^(((0[1-9]|[12]d|3[01])/(0[13578]|1[02])/((19|[2-9]d)d{2}))|((0[1-9]|[12]d|30)/(0[13456789]|1[012])/((19|[2-9]d)d{2}))|((0[1-9]|1d|2[0-8])/02/((19|[2-9]d)d{2}))|(29/02/((1[6-9]|[2-9]d)(0[48]|[2468][048]|[13579][26])|((16|[2468][048]|[3579][26])00))))$

    Thank you

    https://www.ads-software.com/extend/plugins/participants-database/

Viewing 11 replies - 1 through 11 (of 11 total)
  • Thread Starter martinahawkins

    (@martinahawkins)

    Just noticed date of birth is defaulting to jan 1 1970!

    Thread Starter martinahawkins

    (@martinahawkins)

    Date of birth changes to Jan 1 1970 when I change the Form element to date. It changes back to correct date when I change form element to text-line

    Plugin Author xnau webdesign

    (@xnau)

    Martina,

    It kinda sounds like you’re not using the latest version of the plugin. This is a bug that was fixed a couple of releases back.

    Let me know if you’re current and still have the problem.

    Plugin Author xnau webdesign

    (@xnau)

    Also…if a field has a regex defined for it, it will use the regex to validate the field. It’s up to you to write a regex that will reject an incorrect field. If it passes and shouldn’t you need to re-work the regex until it rejects it.

    Thread Starter martinahawkins

    (@martinahawkins)

    yes I am using most current version 1.3.2 and I deactivated and reactivated and still getting problem.

    Plugin Author xnau webdesign

    (@xnau)

    OK, where do you see the 1970 date?

    Thread Starter martinahawkins

    (@martinahawkins)

    I see it when I List Participants

    Thread Starter martinahawkins

    (@martinahawkins)

    Changed it back to date format again there and all records changed to 1 Jan 1970 except 1 which changed from 05/06/69 (5th June 1969) to May 6, 2069

    Plugin Author xnau webdesign

    (@xnau)

    Martina,

    OK, when you edit the date on a record and go back to the list, are you sill getting the 1970 date? Are you using slashes to set the date?

    If so, what is the date format setting for your WP site?

    Thread Starter martinahawkins

    (@martinahawkins)

    WP site format is DD/MM/YYYY
    Using slashes 27/12/1998

    When DOB is set to date format DOB record is blank
    If I set it to text line then DOB is recorded
    If I reset format to Date then dated change to 1 Jan 1970

    If I edit a record and change the DOB to correct date, save and go back to list DOB is blank. If I edit it again it is blank.

    If I change back to text line then all dates change back to correct dates but record I edited is still blank.

    Date Format
    February 29, 2012 * have tried using this one too
    2012/02/29
    02/29/2012
    29/02/2012 * set at his one
    Custom: 29/02/2012

    Plugin Author xnau webdesign

    (@xnau)

    Martina,

    I’m sorry you’re having so much trouble with the date!

    It’s clear I need to offer more ways to process the date values so these problems can be solved.

    Im my tests, setting up my website date format as you have yours, I’ve found the date doesn’t get save is I enter the date in the same format…in other word, if I use slashes. So, I don’t know if you tried this, but try not using slashes to enter the date into the record. That should work, it’s working here.

    Meanwhile, I will fix it so you can enter the date using slashes, and it will work fine. The reason it’s not working is there is a known problem with PHP that if you give it a date formatted with slashes, it will interpret it as MM/DD/YYYY! So there’s your problem, I think.

Viewing 11 replies - 1 through 11 (of 11 total)
  • The topic ‘[Plugin: Participants Database] Date problem’ is closed to new replies.