The CreationDate changed for all my records after daylight savings time.

  • Profile Image
    kingisbyre
    Asked on March 17, 2011 at 12:57 PM

    I cannot chose to extract a unique identifier for my records other than the CreationDate. It is good enough as a identifier if it did not change in your database! The CreationDate must remain the original creation date for the records or I will duplicate my records in my target database when I append non-existing records.

    Either provide a unique identifier for each record or keep the CreationDate. If you cannot provide this I will switch all my forms to another form builder before the next daylight savings time occur.

     

    Thanks,

    Bjorn

  • Profile Image
    DanielGriffin
    Answered on March 17, 2011 at 01:46 PM

    Hi Jeff,

    I see that your timezone is not specified in your account settings, so you are using the default timezone.  If you wish to set it you can do so in the "Account Settings" page.  All time zones are available.  Scroll to the bottom of the page on "My Forms" page, click on "Account Settings" and then change your timezone.

    However, it is possible to use a unique ID for every submission.  Just select unique Id in the list of form fields when you are designing the Notification email:

    If you need a unique id in the form itself then you should embed it in your page and use a hidden field to pass a value.

    Thanks,

    Daniel