Problems with how dates are stored in epoch format during form submissions | Community
Skip to main content
Victor_Herrero
Level 5
February 23, 2021
Question

Problems with how dates are stored in epoch format during form submissions

  • February 23, 2021
  • 2 replies
  • 4187 views

We have been occasionally seeing some bizarre occurrences of people submitting our forms and their date of birth somehow getting confused, then rejected by Salesforce during sync. Here is an example: 

Form Submission original data, notice the value "-61990768800" which i take it is epoch format. 

 

When the lead tried to sync, it failed with this error: "{FIELD_INTEGRITY_EXCEPTION: Date of Birth: invalid date: Thu Aug 06 00:00:00 GMT 5}"

 

The only way I have found to fix this sync error is to delete the date (which displays correctly in Marketo's interface as 4th of August 2005, or at least this is a DoB that makes sense to our business) and use the date picker to put it in again. 

 

While doing that, notice what the old stored value was: "0005-08-04"

 

When I input the value again using the date picker, this is what it looks like: "2005-08-04"

 

It seems like the year gets stored incorrectly, but somehow displays well on the interface. 

Funnily enough, that epoch value (if we are assuming correctly), translated to a date of birth that made no sense to us, since this is not our target audience: 

 

We haven't been able to figure out how this fails and why. Any thoughts? 

 

 

 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

SanfordWhiteman
Level 10
February 23, 2021
Need to the see the page that form is on. Epoch time is not normal; it should be an ISO 8601 string.
SanfordWhiteman
Level 10
February 24, 2021

@victor_herrero do you have a sample page for me to look at?

Victor_Herrero
Level 5
February 25, 2021

Thanks @sanfordwhiteman , 

 

Sure, this seems to be the url the person came through:

 

https://www.culturalcare.com.co/au-pair-best-agency

 

Let me know if the url parameters matter, they include utm fields and gclid, and I can add them. 

SanfordWhiteman
Level 10
February 25, 2021
Hmm. I inspected your DateofBirth validation code and while it isn't exactly the way I'd do it, it doesn't set any new values, so it wouldn't be responsible for changing the value — remember, it's always a String on the wire — from the date-like String ISO 8601 "yyyy-MM-dd" to an epoch-like String "-63998350".

Do you have a guaranteed way I can reproduce the problem?