> ## Content Index
> Fetch the complete content index at: https://blog.jestor.com/llms.txt
> Use this file to discover other available public pages before exploring further.

# Launching - Date functions: do math using time variables, 14 new formulas!
- URL: https://blog.jestor.com/launching-date-functions-do-math-using-time-variables-14-new-formulas/
- Published: 2021-10-29T20:53:47.000Z
- Updated: 2025-03-20T20:20:11.000Z
- Author: Fernando Nakandakari
- Tags: New features, #Migrated-1742495932782, #wp, #wp-post, #Import 2025-03-20 11:39

Including:

DATE\_ADD(date, INTERVAL value addunit)

DATE\_SUB(date, INTERVAL value interval)

MICROSECOND(datetime)

SECOND(datetime)

MINUTE(time)

HOUR(time)

DAY(date)

MONTH(date)

YEAR(date)

DATEDIFF(date1, date2)

DATE(expression)

DATE\_FORMAT(date, format):

TIME\_FORMAT(time, format):

NOW()

## **How to use it**

You can know more about [date functions](https://docs.jestor.com/docs/formula-1?ref=blog.jestor.com)

here

.

---

## **What's Jestor?**

Jestor is a no-code tool to build scalable internal systems, fast. You can create apps, automations, workflows and databases tailor-made for your company. Unlimited users, records, apps and automations.

[**Try it for free here**](https://blog.jestor.com/home-new/)

?