Template

Help

Pricing

Login

Getting Started

Guide

Basic

Resource Permissions Management

Automation Guide

X(Twitter) - Create Tweet

Slack - Send Message to Channel

Telegram - Send Message

WeCom - Send Messages to Group

DingTalk - Send Message to Group

Feishu - Send Message to Group

Integration Guide

Using Integrations in Automation

X(Twitter) Integration

Telegram Bot Integration

Open API

Template Guide

Template Quality Verification

Videos DEMO

Video: What is Bika.ai？ - Proactive AI Automation Database Starter Guide

Video: What is Bika.ai？ - Proactive AI Automation Database Starter Guide

Video: What is Bika.ai？ - Proactive AI Automation Database Starter Guide

Reference

Automation Triggers

Scheduler Trigger

Webhook Received Trigger

Record Created Trigger

Record Match Trigger

Manually Trigger

Datetime Field Reminder Trigger

Form Submitted Trigger

Member Joined Trigger

Automation Actions

Send HTTP Request

Send Message to WeCom Group

Send Message to Feishu Group

Send Message to DingTalk Group

Send Message to Slack Channel

Send Message to Telegram

AI Text Summary

X(Twitter) - Create Tweet

OpenAI - Generate Text

Create Document

Create Node Resource

Integrations

IMAP Email Account

SMTP Email Account

X(Twitter) OAuth2.0

WeCom Group Bot

DingTalk Custom Bot

Feishu Custom Bot

AliCloud Tongyi Qianwen (Qwen)

Tencent Hunyuan

ByteDance Doubao

Node Resources

Report Template

Database Views

Database Fields

Single Line Text

Multi-line Text

Dashboard Widgets

Missions

Submit Multiple Form

Create Multiple Records

AI Create Records

Install Template

Read Template Readme

Redirect Space Node

Ai Wizard

AI Apps Builder

Create Reminder

Create Node Resource

Formula

Encode URL Component

Datetime Format

Last Modified Time

Space

Space Station Sidebar

Permission Management

Release Notes

bika cta

Recommend Reading

Airtable Pricing vs. Bika.ai Pricing: Which is More Advantageous for Investment strategy development?
Data Automation with Bika.ai: Unlocking New Potential for Department head with Weekly meeting reminder (Slack)
Bika.ai vs Zapier: To Automate content posting
Bika.ai vs Airtable: To feature education email
Airtable Pricing vs. Bika.ai Pricing: Which is More Advantageous for enterprise goal management?

Product: Login & Register; Template Center; Integration; API Documentation

Support: Help Center; Tutorial; Roadmap; Brand Assets; Privacy Policy; Terms of Service

Contacts: Contact Customer Service; Contact Sales; support@bika.ai

Language: English; 简体中文; 繁體中文; 日本語

© 2024 Copyright Bika.ai

Formats a date as text in a custom format.

【date】The date to be formatted.
【output_specifier】The format specifier. For example:
"DD-MM-YYYY" means "day-month-year", see example one;
"YYYY / MM / DD" means "year/month/day", see example two;
"MM.DD" means "month.day", see example three.

After formatting, the date becomes a string.

For supported date format specifiers, see the link below.

Datetime Format

Formats a date as text in a custom format. 【date】The date to be formatted. 【output_specifier】The format specifier. For example: "DD-MM-YYYY" means "day-month-year", see example one; "YYYY / MM / DD" means "year/month/day", see example two; "MM.DD" means "month.day", see example three. After formatting, the date becomes a string. For supported date format specifiers, see the link below.

Input formula

Input formula

Select a formula

Number

Sum

Average

Max

Min

Round

Round Up

Round Down

Ceiling

Floor

Even

Odd

Int

Abs

Sqrt

Mod

Power

Exp

Log

Value

Text

Concatenate

Find

Search

Mid

Replace

Substitute

Len

Left

Right

Lower

Upper

Rept

T

Trim

Encode URL Component

Logic

If

Switch

True

False

And

Or

Xor

Blank

Error

Is Error

Not

Date

Today

Now

To Now

From Now

Date Add

Datetime Diff

Workday

Workday Diff

Is After

Is Before

Is Same

Datetime Format

Datetime Parse

Datestr

Timestr

Year

Month

Weekday

Weeknum

Day

Hour

Minute

Second

Set Locale

Set Timezone

Created Time

Last Modified Time

Array

Array Compact

Array Unique

Array Join

Array Flatten

Count

CountA

CountIf

CountAll

Object

Record ID

DATETIME FORMAT

Formats a date as text in a custom format. 【date】The date to be formatted. 【output_specifier】The format specifier. For example: "DD-MM-YYYY" means "day-month-year", see example one; "YYYY / MM / DD" means "year/month/day", see example two; "MM.DD" means "month.day", see example three. After formatting, the date becomes a string. For supported date format specifiers, see the link below.

Usage

DATETIME_FORMAT(date, [specified_output_format])

Example

DATETIME_FORMAT(TODAY(), "DD-MM-YYYY")
=> 10-06-2024