---
title: Data Transforms
description: Learn how to use data transform actions in APIANT to convert or manipulate data formats—such as datetimes—by selecting categorized transform options from the automation editor’s menu.
---

[Skip to content](https://help.apiant.com/data-transforms#main-content)

English

Show submenu for translations

![apiant-logo-forum.png\]](https://help.apiant.com/hs-fs/hubfs/apiant-logo-forum.png?height=40&name=apiant-logo-forum.png)

Open main navigation

Close main navigation

- English
  
  Show submenu for translations
- Go to apiant.com

 Go to apiant.com

 Hello. How can we help you?

- There are no suggestions because the search field is empty.

1. [Help Center](https://help.apiant.com/?hsLang=en)
2. [AutomationEditor](https://help.apiant.com/automationeditor?hsLang=en)
3. [Building Automations](https://help.apiant.com/automationeditor?hsLang=en#building-automations)

# Data Transforms

## Learn how to use data transform actions in APIANT to convert or manipulate data formats—such as datetimes—by selecting categorized transform options from the automation editor’s menu.

Data values often need to be converted from one format to another, or manipulated in some fashion, in order to be in a format needed by a certain action input. A common data formatting problem is for datetimes.

The system provides a variety of data transform actions, accessible by clicking the "plus" icon:

![Document image](https://images.archbee.com/Y2QGD8otsIOv4e0hQQnqa/LF9coIcyrgr44COJ2gKFC_image.png?format=webp)

 

Selecting that menu option opens a new menu of transforms categorized by the type of data:

![Document image](https://images.archbee.com/Y2QGD8otsIOv4e0hQQnqa/rvm0bE5KWPLUsUWmXWJMb_image.png?format=webp)

 

Select a category to then view the available actions. Each action can be moused over for a description of its functionality:

![Document image](https://images.archbee.com/Y2QGD8otsIOv4e0hQQnqa/MIH4XVshDCNB76g7uuVtt_image.png?format=webp)

 

 

- [ZoomConnect](https://help.apiant.com/zoomconnect?hsLang=en)
- [ShopConnect](https://help.apiant.com/shopconnect?hsLang=en)
- [AppConnect](https://help.apiant.com/appconnect?hsLang=en#main-content)

    - [AppConnectPrebuiltConnectors](https://help.apiant.com/appconnect?hsLang=en#appconnectprebuiltconnectors)
- [CalendarConnect](https://help.apiant.com/calendarconnect?hsLang=en)
- [CRMConnect](https://help.apiant.com/crmconnect?hsLang=en#main-content)

    - [Mindbody to HubSpot](https://help.apiant.com/crmconnect?hsLang=en#mindbody-to-hubspot)
    - [Cliniko to HubSpot](https://help.apiant.com/crmconnect?hsLang=en#cliniko-to-hubspot)
    - [Cliniko to ActiveCampaign](https://help.apiant.com/crmconnect?hsLang=en#cliniko-to-activecampaign)
    - [DonorPerfect to HubSpot](https://help.apiant.com/crmconnect?hsLang=en#donorperfect-to-hubspot)
    - [DonorPerfect to ActiveCampaign](https://help.apiant.com/crmconnect?hsLang=en#donorperfect-to-activecampaign)
    - [Mindbody to ActiveCampaign](https://help.apiant.com/crmconnect?hsLang=en#mindbody-to-activecampaign)
- [MailConnect](https://help.apiant.com/mailconnect?hsLang=en)
- [AutomationEditor](https://help.apiant.com/automationeditor?hsLang=en#main-content)

    - [KeyConcepts](https://help.apiant.com/automationeditor?hsLang=en#keyconcepts)
    - [AccountManagement](https://help.apiant.com/automationeditor?hsLang=en#accountmanagement)
    - [ManagingAutomations](https://help.apiant.com/automationeditor?hsLang=en#managingautomations)
    - [App Connections](https://help.apiant.com/automationeditor?hsLang=en#app-connections)
    - [Building Automations](https://help.apiant.com/automationeditor?hsLang=en#building-automations)
- [APIANTforBuilders](https://help.apiant.com/apiantforbuilders?hsLang=en)
- [APIANTInline](https://help.apiant.com/apiantinline?hsLang=en)
- [WhatisAPIANT?](https://help.apiant.com/whatisapiant?hsLang=en)
- [ContactAPIANTsupport](https://help.apiant.com/contactapiantsupport?hsLang=en)

[![APIANT](https://help.apiant.com/hubfs/APIANT_LOGO-2.svg "APIANT")](http://apiant.com)

apiant.com Help Center

Copyright © 2026, APIANT