I am trying to extract data from a Booking site using Zapier to populate Deal Information in HubSpot. I can pull the start date and the end date from the Booking site using Zapier. However, I need to convert the start date and end to text fields, so that I can concatenate the data to create the Deal Name to send to HubSpot. Does anyone have any ideas on how I can accomplish this?
Manipulating and combining date fields from a trigger
Hi
Perhaps you can provide screenshots of what you’re trying to do and the desired end result, thanks.
Troy, Thank you for the quick response. Here is what I am trying to do I want to take the date information in M2 and N2, convert the information to text fields and then concatenate the two fields into one field to create the Deal Name to send to HubSpot. Thanks,
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/7b46e9b7-095f-4e1b-b9c6-84227e2f7aa7.png)
Hey there
https://zapier.com/help/create/format/modify-date-and-time-formats-in-zaps
It allows you to take the date, and turn it into a pretty date which you can then parse into the next step. So for example, once you’ve parsed the date, you can concatenate your value with the date.
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/d01df105-0020-4062-afa7-99de047fddfc.png)
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/eee07d8d-752b-41d7-ab65-2b78823aa22f.png)
Hope that helps!
You can use Formatter > Date & Time > Format steps to convert the format for Timestamps.
You can create a HubSpot Deal Title by inserting a combo of Static values and Dynamic data points from previous steps.
For example: [DATE_ARRIVE] - [DATE_LEAVE], where [VARIABLES] are dynamically mapped in the Zap and “ - ” is static
Hey
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.