Convert and check dates with the Date Utilities pipe

Use the Tadabase Date Utilities pipe to convert a date to another time zone or format, check it (is day, is month, is leap year) and add or count days.

  • Verified Nov 17, 2026
  • Classic builder

On this page
  1. Install the pipe
  2. Convert a date to another time zone or format
  3. Format letters and time zone names
  4. Check a date
  5. Get, change and count dates

The Tadabase Date Utilities pipe works on a date and time you pass in: it converts it to another time zone or format, checks it (is it a Monday, this month, a leap year), and adds, sets or counts days, hours and business days.

Install the pipe #

  1. Open Pipes In the builder, click Pipes in the left menu, then click Install Pipe.
  2. Find the pipe Type Date Utilities in the Search... box and click the Tadabase Date Utilities card, then click Install.
  3. Set the defaults The window asks for Timezone, Format and Datetime. These are the defaults every call uses when you do not pass a value. Leave Datetime empty; you map it to a field when you run the pipe.
  4. Finish Click Install. The pipe opens on its General tab.

To change the defaults later, open the pipe's Global Parameters tab, edit Value and click Save.

The Tadabase Date Utilities pipe on its Global Parameters tab, listing Timezone, Format and Datetime with their default values
ParameterWhat to enterDefault
DatetimeThe date and/or time to work on, as yyyy-mm-dd (for example 2022-11-28), with a time if you need one.none
TimezoneThe time zone of Datetime, as a time zone name such as America/Los_Angeles.America/Los_Angeles
FormatHow the returned date is written (see the format letters below).m/d/Y H:i:s

Convert a date to another time zone or format #

Use the Convert Time call. It reads Datetime in Timezone and returns it in Destination Timezone, written in Format.

  1. Add the pipe where you need it For example, add a Trigger Pipe action to a workflow. Use pipes in your app covers the other places.
  2. Choose the call In Pipe Method, choose Convert Time.
  3. Map the input Under Parameters, set Datetime to your date field and Destination Timezone to the time zone you want, for example Asia/Jerusalem. Set Timezone or Format only if they differ from the pipe's defaults.
  4. Use the output The converted date is returned as Response. Use it in a later step, for example to update a text field.

To get a standard timestamp instead, use Convert to RFC 3339. It always uses the format Y-m-d\TH:i:sP.

Format letters and time zone names #

Format is a pattern of letters, each standing for one part of the date, with the separators you want between them. With the default m/d/Y H:i:s, 28 November 2022 at 9:30 is written 11/28/2022 09:30:00.

LetterPart of the dateExample
dDay of the month, two digits28
mMonth, two digits11
YYear, four digits2022
HHour, 24-hour clock, two digits09
iMinutes, two digits30
sSeconds, two digits00
POffset from UTC-08:00

Timezone and Destination Timezone take names from the IANA time zone database, written as Region/City: for example America/New_York, America/Los_Angeles, Europe/London or Asia/Jerusalem.

Check a date #

These calls check Datetime and return the answer in Response and Response String. Map them the same way as Convert Time.

CallChecks whether the date isExtra parameter
Is Daya given day of the weekDay Name, for example Monday
Is Monthin a given monthMonth, for example December
Is Current Weekin the current weeknone
Is Current Monthin the current monthnone
Is Current Yearin the current yearnone
Is Yesterdayyesterdaynone
Is Tomorrowtomorrownone
Is Leap Yearin a leap yearnone

Two more calls check business days. Both take a Region (default us).

CallReturns
Check if Date is a HolidayIs Holiday?, Holiday Name, Holiday ID
Check if Date a Business DayIs Business Day?, Next Business Day, Previous Business Day, Current or Next Business Day, Current or Previous Business Day

Get, change and count dates #

The rest of the calls return a value from the date, a changed date, or a count. Unless a parameter is listed, they use only Datetime, Timezone and Format.

CallsExtra parametersReturns
Get Year, Get Second, Get Weekday Number, Get Day Name, Get Month Name, Get Quarter, Get Total Days of MonthnoneResponse
Set to Beginning of Day, Set to End of Day, Set to Beginning of Week, Set to End of Week, Set Beginning of Month, Set End of Month, Set Beginning of Quarter, Set End of QuarternoneResponse
Set Hour, Set MinuteHour Number, Minute Number (0-59)Response
Add Days, Add Weeks, Add Months, Add Years, Add Hours, Add Minutes, Add Secondshow many to add, for example Number of DaysResponse
Subtract Days, Subtract Hours, Subtract Minutes, Subtract Secondshow many to subtract, for example Number of DaysResponse
Get Difference in DaysEnd DateResponse
Subtract TimesEnd TimeTotal Hours, Total Minutes, Total Seconds
Get Next Business Day, Get Previous Business DayRegionAdded Business Day or Previous Business Day
Add Business Days, Subtract Business DaysRegion, Number of Business Days to Add or Number of Business Days to SubtractAdded Business Day
Total Business DaysRegion, End DateTotal Business Days
Total Business Days in MonthRegionTotal Business Days
Get AgenoneTotal Days, Total Months, Years, Full Formatted Age, Short Age
Time AgononeResponse: how long ago the date was. A current or future date returns just now.
Time Difference in Natural LanguageEnd Date and TimeResponse
Combine Seperate Date and Time FieldsTime, Inpurt FormatStatus, Result: a date and time you can save to a date/time field

Was this page helpful?

Something wrong or missing on this page? Tell us.