I am trying to convert a single line text Hubspot property ‘ Date of Birth’ to a date property named DOB. I am in Australia so DD/MM/YYYY is what I am trying to achieve.The date formatter does a great job when the day is greater than 12, then the property is filled correctly, if the the day is 12 or less than it will swap them around.Example :13/04/2020 (13th April 2020) will be 13/04/2022 on Hubspot (Correct format) 12/04/2020 (12th April 2020) will be 04/12/2022 on Hubspot (Incorrect format)See images attached; The Hubspot date picker is set to DD/MM/YYYY and the region is set to my local time zone, however when the submission is made, the DD/MM switches when the day is 12 or less.Does the formatting function allow for single line text to date conversation or am I missing something?Please help!

Best answer

Date and month reversed in HubSpot

2 years ago
31 January 2022
2 replies
312 views

Userlevel 1

Relliott
Beginner
3 replies

I am trying to convert a single line text Hubspot property ‘ Date of Birth’ to a date property named DOB.
I am in Australia so DD/MM/YYYY is what I am trying to achieve.

The date formatter does a great job when the day is greater than 12, then the property is filled correctly, if the the day is 12 or less than it will swap them around.

Example :

13/04/2020 (13th April 2020) will be 13/04/2022 on Hubspot (Correct format)
12/04/2020 (12th April 2020) will be 04/12/2022 on Hubspot (Incorrect format)

See images attached;

The Hubspot date picker is set to DD/MM/YYYY and the region is set to my local time zone, however when the submission is made, the DD/MM switches when the day is 12 or less.

Does the formatting function allow for single line text to date conversation or am I missing something?

Please help!

icon

Best answer by Troy Tessalone 31 January 2022, 15:41

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Userlevel 7

+14

Troy Tessalone
Certified Zapier Expert
24087 replies
2 years ago
31 January 2022
Answer

Hi @Relliott

Try using 1 Formatter step to put the data in this format, then use 1 Formatter step to Split the value by dashes, which will give you each of the variables as individual data points, then you can assemble how you choose.