TexAu action

Format Date and Time (Utility)

Converts a date-time string to UTC timezone and extracts individual date and time components.

Run in Studio →All TexAu actions
Texau logoTexAu
texau-format-date-time
enrichmentReturns in secondsLight tier
Input

What it needs.

Map each field to a column in your table. Optional fields can stay empty.

FieldType
  • date
    Original date-time input string to parse and format (e.g., ISO 8601, common date formats).
    text

When to use this.

The texau-format-date-time action is designed to convert a date-time string into the UTC timezone while extracting essential components such as year, month, day, and time. This action accepts a single input parameter, 'date' (text), which can be in various formats, including ISO 8601 and other common date representations. The output includes a range of fields, such as 'formatted_date' (text), 'localized_date_time' (text), and 'unix_timestamp' (text), providing comprehensive insights into the parsed date-time. This action is particularly useful for applications requiring date-time normalization, such as event scheduling, data analysis, and reporting, making it an essential tool in the enrichment category for developers and data analysts.

Output

What it returns.

Every field this action writes back to the row. Click a line to expand nested objects.

FieldType
  • applied_locale
    Applied Locale
    nullabletext
  • applied_timezone
    Applied Timezone
    nullabletext
  • day
    Day
    number
  • formatted_date
    Formatted Date
    text
  • full_date_time
    Full Date Time
    nullabletext
  • localized_date_time
    Localized Date Time
    nullabletext
  • localized_date_with_month_name
    Localized Date With Month Name
    nullabletext
  • localized_date_with_weekday
    Localized Date With Weekday
    nullabletext
  • localized_short_date
    Localized Short Date
    nullabletext
  • localized_time
    Localized Time
    nullabletext
  • month_name
    Month Name
    nullabletext
  • month_number
    Month Number
    nullablenumber
  • original_input
    Original Input
    nullabletext
  • parsed_successfully
    Parsed Successfully
    nullableboolean
  • short_year
    Short Year
    nullablenumber
  • time
    Time
    nullabletext
  • unix_timestamp
    Unix Timestamp
    nullablenumber
  • year
    Year
    number
Workflow

How this fits a workflow.

Trigger → Format Date and Time (Utility) → enrich → push to your CRM. You set it up once; after that it runs without you.

  1. Step 1TriggerNew row, form submit, or schedule.
  2. Step 2Format Date and Time (Utility)The TexAu action runs.
  3. Step 3EnrichWaterfall fills missing fields.
  4. Step 4Push to CRMHubSpot / Pipedrive / Zoho CRM / GoHighLevel.

Two actions you can chain after this one:

Format Date and Time (Utility)Remove Extra Whitespace (Utility)Identify Email Type (Utility)
Reliability

Throughput & reliability.

How fast it drains a table, and what happens when the upstream provider has a bad day.

  • Per-minute limit300 / min
  • Per-day limit50,000 / day
  • RetriesAutomatic w/ backoff
  • Failed lookupsZero credits

Who runs this

GTM EngineerRevOpsAgency

Light tier. See pricing; per-action credit cost is private.

Related

More TexAu actions.

FAQ.

Mostly. Fast actions fill the cell in a few seconds. Long-running ones run in the background and write back to the row when they finish, so you can close the tab.

No. A failed lookup costs zero credits. When a provider misses or times out, the waterfall moves to the next one and you only pay for the match you actually got.

No. Run it on one cell, on a selection, on the whole table, or on a schedule. Same action either way.

HubSpot, Pipedrive, Zoho, and GoHighLevel are bidirectional, with Salesforce coming soon. Smartlead, Instantly, Lemlist, HeyReach, Apollo Sequences, and Reply.io for outbound.

Run Format Date and Time (Utility) in 60 seconds.

Connect the account, drop the action on a column, run it on your rows.

Start free →All TexAu actions