How do I make the date transfer correctly?

  • Profile Image
    markrojek1
    Asked on March 03, 2016 at 03:29 PM

    I have expiration dates set on my form along with the formatting that if the date is before "today+30" to transfer the date to a hidden line.

    That line is then in the Admin email, so it is only visible if the date is within the next 30 days.  This works fine, but the date format that comes through on the email doesn't make any sense and is just a combination of numbers such as "16863" for March 3, 2016.

    Thanks,

    Mark

  • Profile Image
    Boris
    Answered on March 03, 2016 at 04:48 PM

    It looks like the date string is being passed as a "number" to the new field.

    Please try editing your existing insert condition, and switch it from Copy a field's value to Calculate a field's value, which will then looks like this:

    Now click on the 0-9 area of the Expiration Date field, so that it switches to "text" mode with displaying A-Z:

    Saving the condition while it is set to pass the value as text, will ensure that your date is correctly passed to the other field:

    Please try it out, and let us know if it fixed the issue you were having. Thank you.

  • Profile Image
    markrojek1
    Answered on March 03, 2016 at 05:05 PM

    Exactly what I needed.  Thanks for the quick and accurate answer!