# Netsuite Connector Issue **URL:** \ **Category:** HubSpot-built Apps\ **Tags:** integrations\ **Created:** [September 16, 2024, 4:39pm UTC](https://community.hubspot.com/t/netsuite-connector-issue/116410 "2024-09-16T16:39:58Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![SHQNY](https://avatars.discourse-cdn.com/v4/letter/s/f05b48/32.png) [@SHQNY](https://community.hubspot.com/u/SHQNY)\ **Post date:** [September 16, 2024, 4:39pm UTC](https://community.hubspot.com/t/netsuite-connector-issue/116410/1 "2024-09-16T16:39:58Z")
Hi! I’ve encountered a strange issue in the my Hubspot \> Netsuite sync, and I’m hoping someone can help me figure out a solution. We have the sync set up so that once a Deal is marked as Closed-Won in Hubspot, it is pushed into Netsuite as an Opportunity - Won record. However, when the data is pulled into Netsuite, all of the dates entered in the Hubspot Deal show up as the day prior in Netsuite. For example, if a deal has an event date listed as 11/01/2024 on the deal record, the Opportunity record created in Netsuite will display the event date as 10/31/2024. I have checked, and both accounts are set to the same time zone, so I don’t think that is the problem. Any ideas or suggestions on how to fix this issue, or additional settings I should invesigate? ---
**Author:** ![jnix284](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jnix284/32/29_2.png) [@jnix284](https://community.hubspot.com/u/jnix284)\ **Post date:** [September 16, 2024, 5:04pm UTC](https://community.hubspot.com/t/netsuite-connector-issue/116410/2 "2024-09-16T17:04:57Z")
This is quite strange @SHQNY, happy to help see if someone I know has any ideas. @crispyGTM @tmcginnis have either of you run into any issues where Netsuite is showing dates as the day prior to the date in HubSpot (e.g. HubSpot close date is 11/1/2024, Netsuite shows 10/31/2024) or know someone else at A8 who’s worked closely with Netsuite that might have insight? ---
**Author:** ![tmcginnis](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/tmcginnis/32/4408_2.png) [@tmcginnis](https://community.hubspot.com/u/tmcginnis)\ **Post date:** [September 16, 2024, 5:08pm UTC](https://community.hubspot.com/t/netsuite-connector-issue/116410/3 "2024-09-16T17:08:06Z")
@Jnix284 - is the Netsuite Date field a DateTime or just a date picker? HubSpot’s Close Date is datetime. When those are mapped to date pickers (without the time) it’ll default to midnight UTC, the day before. ---
**Author:** ![SHQNY](https://avatars.discourse-cdn.com/v4/letter/s/f05b48/32.png) [@SHQNY](https://community.hubspot.com/u/SHQNY)\ **Post date:** [September 16, 2024, 5:14pm UTC](https://community.hubspot.com/t/netsuite-connector-issue/116410/4 "2024-09-16T17:14:43Z")
The feilds that aren’t lining up are custom feilds in both Netsuite and Hubspot, and both are date pickers. ---
**Author:** ![jnix284](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jnix284/32/29_2.png) [@jnix284](https://community.hubspot.com/u/jnix284)\ **Post date:** [September 16, 2024, 5:36pm UTC](https://community.hubspot.com/t/netsuite-connector-issue/116410/5 "2024-09-16T17:36:40Z")
Thank you @tmcginnis you’re awesome, I forgot that DateTime mapped to Date Picker does this! @SHQNY I saw your reply that both properties are custom fields that are Date Picker only, are you not using the default HubSpot Closed Won Date property? Based on the DateTime to Date Picker conversion issue and it being so similar to what you’re encountering, I feel like there has to be a connection somehow. Can you dig deeper into the custom property in HubSpot to make sure it’s not a DateTime property? ---
**Author:** ![SHQNY](https://avatars.discourse-cdn.com/v4/letter/s/f05b48/32.png) [@SHQNY](https://community.hubspot.com/u/SHQNY)\ **Post date:** [September 16, 2024, 6:42pm UTC](https://community.hubspot.com/t/netsuite-connector-issue/116410/6 "2024-09-16T18:42:19Z")
We do use the default HubSpot Closed Won Date property, and it is actually syncing correctly to Netsuite. However, since we are selling an Event space, we needed to include the date the event will take place on the Deal record, so we created a custom Date Picker field. In Netsuite, we created a similar feild (also a Date Picker) on Opportunity records. So while the Closed Won Date is coming through to the Opportunity in Netsuite correctly, the Event Date is showing up as the date prior. I hope this clarifies the issue! Do you think switching them all to Date Time feilds would fix the issue? ---
**Author:** ![jnix284](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jnix284/32/29_2.png) [@jnix284](https://community.hubspot.com/u/jnix284)\ **Post date:** [September 16, 2024, 7:29pm UTC](https://community.hubspot.com/t/netsuite-connector-issue/116410/7 "2024-09-16T19:29:53Z")
@SHQNY I think it would definitely be worth testing the DateTime property to see if you can get it to sync the correct date information. ---
**Author:** ![SHQNY](https://avatars.discourse-cdn.com/v4/letter/s/f05b48/32.png) [@SHQNY](https://community.hubspot.com/u/SHQNY)\ **Post date:** [September 26, 2024, 5:26pm UTC](https://community.hubspot.com/t/netsuite-connector-issue/116410/8 "2024-09-26T17:26:13Z")
Switching all of the fields to DateTime properties seemed to do the trick! Thank you for the suggestion! ---
**Author:** ![tmcginnis](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/tmcginnis/32/4408_2.png) [@tmcginnis](https://community.hubspot.com/u/tmcginnis)\ **Post date:** [September 26, 2024, 5:34pm UTC](https://community.hubspot.com/t/netsuite-connector-issue/116410/9 "2024-09-26T17:34:27Z")
@SHQNY - great news! Glad it worked out. Happy to help! 🙂 ---
**Author:** ![erpnetsuite](https://avatars.discourse-cdn.com/v4/letter/e/8797f3/32.png) [@erpnetsuite](https://community.hubspot.com/u/erpnetsuite)\ **Post date:** [October 21, 2024, 6:27pm UTC](https://community.hubspot.com/t/netsuite-connector-issue/116410/10 "2024-10-21T18:27:41Z")
Hi, Thanks for sharing the details! It looks like the **date discrepancy** is related to how HubSpot and NetSuite handle **date/time fields** during sync, which can sometimes lead to timezone or formatting misalignments. Since you mentioned that both custom fields (Event Date) are using **Date Picker fields** in HubSpot and NetSuite, let’s explore a few possible causes and solutions: ### 1. **Root Cause: Midnight UTC Default Behavior** - **HubSpot’s Date Picker fields** are stored without time components but, under the hood, the system defaults to **midnight UTC (00:00)**. - During the sync, if **NetSuite interprets this value** with a different timezone (even if both systems are in the same zone), it may show as the **day prior** because of the time shift from midnight UTC. ### 2. **Potential Solutions** #### **Option 1: Switch to DateTime Fields** - Updating the **custom Event Date fields** in both HubSpot and NetSuite to **DateTime fields** might resolve the issue. - Even if you don’t need time information, the DateTime fields can store and sync data more accurately across platforms, eliminating timezone shifts. - Test this solution in your sandbox environment by: 1. Changing the custom fields to DateTime in both systems. 2. Syncing a few test records and confirming if the dates align properly. #### **Option 2: Adjust via Workflow or Script in NetSuite** - If switching to DateTime fields isn’t ideal, a **workflow or SuiteScript** in NetSuite could adjust the event date to correct the discrepancy during sync. - For example, you could write a **script to add a day** to the Event Date if it’s coming from HubSpot, ensuring consistency without changing field types. #### **Option 3: Middleware Adjustment** - If you are open to using a middleware like **Celigo** , you could apply a simple transformation rule to adjust the date value before it’s pushed into NetSuite. ### 3. **Check for Other Sync Settings** - Verify if **field-level mapping settings** are consistent in both systems, ensuring that the field types match exactly. - Also, confirm there are no **time-based workflow rules** in either system that might alter the date during the sync. I’d recommend starting with **Option 1** since using **DateTime fields** is often the cleanest fix for these types of issues. Let me know how it goes or if you need further help implementing a solution! Best regards, David [NetSuite & HubSpot Integration](https://erppeers.com/hubspot-netsuite-integration/) Specialist