Date of birth on landing page comes through in wrong format to marketo database

[Nejka_McGeachie]

Hi guys,

I'm pretty confused by this one! I have a marketo landing page with a form asking for Date of birth. The calendar pops up, you choose your date but when it gets through to marketo database (if it comes through), it shows in opposite way - So we are in Australia and our date for example is 05/09/1981 (5 September), but marketo changes to 9th May. If I choose 19/05, nothing comes through (because it obviously can't convert). It's from marketo to marketo-how does this happen?? I know that it's the American way to write opposite but the point is that the form itself displays the correct date, it says dd/mm/yyyy as format.

If you log in through Sitecore which is our website platform and pop in the date in your account there, it comes through correctly and sits in marketo as dd/mm/yyyy.

Any suggestions how to fix that?

[SanfordWhiteman]

The proper way to send dates to any modern db (not just Marketo) is ISO 8601 format:

  yyyy-MM-dd

For example

  1981-09-05

This is understood in all locales.

You can display the date any way you want, but this is how the value should be sent to Marketo.