---
title: "ROUNDDATETIME()"
slug: "rounddatetime"
updated: 2025-10-14T16:28:33Z
published: 2025-11-19T15:54:21Z
canonical: "support.tulip.co/rounddatetime"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://support.tulip.co/llms.txt
> Use this file to discover all available pages before exploring further.

# ROUNDDATETIME()

## Description

Truncates a date to the given unit. If a tz identifier is provided, uses that time zone instead of the local time zone.

## Available In

- **Apps**
- **Automations**
- **Analysis**

## Syntax

ROUNDDATETIME(date: Datetime or Date, truncation: Text, timezone?: Text)

## Example

ROUNDDATETIME(@App Info.Current Date and Time, 'month', 'America/New_York') = 01/01/2019 00:00