The Split Date-Time action within the Data Splitter Actions App by Integration Glue allows you to break down a single date-time value into separate components, such as the year, month, day, hour, minute, second, etc. This action is useful when you need to manipulate specific parts of a date-time value for different purposes within your workflow, like creating automated processes based on certain times or extracting specific details for further use.
By splitting the date-time into its individual components, the app enables you to work with each component independently, ensuring that you can target specific time elements for things like calculations, filtering, or organizing data in ways that are more actionable within HubSpot workflows.
This action is particularly useful when:
- You need to extract and use specific components of a date-time value (e.g., the month or year) in your workflow.
- You want to perform actions based on certain time elements (like sending an email on the first day of the month).
- You need to work with granular details of a date-time property for reporting, automation, or other workflow actions.
- DateTime Property refers to the date-time property in HubSpot that you want to split into individual components. You will choose the field that contains the date and time data that needs to be broken down.
- Default Timezone (will set to UTC if left blank) allows you to specify the default time zone for the date-time value. If you leave it blank, the system will assume UTC (Coordinated Universal Time) as the default time zone. This is useful when dealing with date-times in different time zones to ensure consistency.
- Date Output defines where the date part (i.e., the year, month, and day) of the date-time will be saved. After the date-time is split, the date component will be stored in the specified property.
- Time Output defines where the time part (i.e., the hour, minute, and second) of the date-time will be saved. After the date-time is split, the time component will be stored in the specified property.
- Time Output Format (if left blank, format will be H:M 24H) allows you to specify the format in which the time should be saved. For example, you can choose to display the time in a 12-hour or 24-hour format. If left blank, it will default to the 24-hour format (e.g., 15:30 for 3:30 PM).
Step 1: Create a New Workflow
- In your HubSpot account, go to the Automation tab and select Workflows.
- Click on the Create workflow button.
- Choose a workflow type (e.g., Contact-based, Deal-based, etc.) depending on your use case.
- Set your workflow’s trigger criteria.
Step 2: Add the 'Split Date-Time' Action
- After setting up your workflow trigger, click the + button to add an action.
- In the action sidebar, scroll down and search for Data Splitter Actions.
- Select the Split Date-Time action from the list.
- Click Save to add the action to your workflow.
Step 3: Configure the Action
-
DateTime Property:
- Choose the HubSpot property that contains the date-time value you want to split (e.g., "Date of Birth", "Deal Close Date").
-
Default Timezone:
- Select the default timezone for the date-time value. If no specific timezone is needed, leave this field blank, and it will default to UTC.
-
Date Output:
- Choose the property where you want the date part of the date-time to be saved (e.g., a custom date property).
-
Time Output:
- Choose the property where you want the time part of the date-time to be saved (e.g., a custom time property).
-
Time Output Format:
- (Optional) Specify how the time should be formatted. If left blank, it will default to the 24-hour format (e.g., 15:30). You can set it to a 12-hour format (e.g., 3:30 PM) if needed.
Step 4: Review and Activate the Workflow
- After configuring the action, review the settings to ensure everything is correct.
- Save the workflow and check all other actions to ensure they are properly set up.
- Once satisfied, click Review and Publish to activate the workflow.
Step 5: Test the Workflow
- Trigger the workflow by performing an action (e.g., creating or updating a record).
- Check the records to verify that the date and time have been split into the specified fields correctly.
Step 6: Use the Split Data for Further Actions
- You can now use the split date and time values in subsequent workflow actions (e.g., for reporting, filtering, or other data manipulations).