How do I make the date transfer correctly?

  • markrojek1
    Asked on March 3, 2016 at 3: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

  • Boris
    Replied on March 3, 2016 at 4: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:

    How do I make the date transfer correctly? Image 1 Screenshot 40

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

    How do I make the date transfer correctly? Image 2 Screenshot 51

    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:

    How do I make the date transfer correctly? Image 3 Screenshot 62

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

  • markrojek1
    Replied on March 3, 2016 at 5:05 PM

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