Format Date and Time (Utility)
Texau → Format Date and Time (Utility)
Converts a date-time string to UTC timezone and extracts individual date and time components.
Input
What it needs.
Map each field to a column in your table. Optional fields can stay empty.
dateOriginal 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.
applied_localeApplied Localenullabletextapplied_timezoneApplied TimezonenullabletextdayDaynumberformatted_dateFormatted Datetextfull_date_timeFull Date Timenullabletextlocalized_date_timeLocalized Date Timenullabletextlocalized_date_with_month_nameLocalized Date With Month Namenullabletextlocalized_date_with_weekdayLocalized Date With Weekdaynullabletextlocalized_short_dateLocalized Short Datenullabletextlocalized_timeLocalized Timenullabletextmonth_nameMonth Namenullabletextmonth_numberMonth Numbernullablenumberoriginal_inputOriginal Inputnullabletextparsed_successfullyParsed Successfullynullablebooleanshort_yearShort YearnullablenumbertimeTimenullabletextunix_timestampUnix TimestampnullablenumberyearYearnumber
Compose
How this fits a workflow.
The next 2 actions most operators chain after this one.
enrichment
Remove Extra Whitespace (Utility)
Cleans up text by removing extra spaces, tabs, and newlines while preserving single spaces.
Identify Email Type (Utility)
Classifies an email address as personal, business, educational, or freemail and extracts the provider domain.
Find URL Redirect Destination (Utility)
Resolves a URL to its final destination and returns the full redirect chain with HTTP status codes.
Workflow
A real example.
Trigger → format date and time (utility) → enrich → push to your CRM. You set it up once; after that it runs without you.
Built for
Who runs this.
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
Related
More Texau actions.
Remove Extra Whitespace (Utility)
Cleans up text by removing extra spaces, tabs, and newlines while preserving single spaces.
Identify Email Type (Utility)
Classifies an email address as personal, business, educational, or freemail and extracts the provider domain.
Find URL Redirect Destination (Utility)
Resolves a URL to its final destination and returns the full redirect chain with HTTP status codes.
Normalize Phone Number (Utility)
Normalizes and validates a phone number to E.164, national, and RFC3966 formats with country metadata.
FAQ.
Is this real-time?
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.
Do I get charged on failure?
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.
Do I have to run it row by row?
No. Run it on one cell, on a selection, on the whole table, or on a schedule. Same action either way.
What CRMs can I push results to?
HubSpot, Salesforce, Pipedrive, Zoho, and GoHighLevel are bidirectional. 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.