# Formulas - Date

Updated by Marco de Vita

If this is your first time using Formulas, please check our Getting Started guide here and our crash course here

Use the Date Formulas if you need to include the date and/or time to your chatbot, calculate delivery dates or show the date in a different format for your customers located in different regions.

Read this article for some practical examples of how to use all the different Date Formulas available within Landbot.

• AddDays
• AddMonths
• AddYears
• Now
• Today
• ToDate

#### AddDays

##### Add 3 days to the specified date 2020/01/01

`AddDays(@my_date,3)`

#### AddMonths

##### Add 4 months to the specified date 2020/01/01
`AddMonths(@my_date,4)`

#### AddYears

##### Add 2 years to the specified date 2020/01/01
`AddDaysAddYears(@my_date,2)`

#### Now

##### Get the current timestamp (date and hours) for a specific TimeZone

CheckΒ this linkΒ to see the supported values (TZ database name column).

`Now("Africa/Abidjan")`

##### Get Date (YYYY-MM-DD format) and Time (in HH:MM:ss)

`GetValue(Split(Now("Europe/Madrid"),"."),0)`

##### Get Date in YYYY-MM-DD

`GetValue(Split(GetValue(Split(Now("Europe/Madrid"),"."),0)," "),0)`
##### Get Time in HH:MM:ss

`GetValue(Split(GetValue(Split(Now("Europe/Madrid"),"."),0)," "),1)`

##### Get Date in DD-MM-YYYY format

In this case, we need to extract and store every element separately and join them after with a Set Variable block:

To get the variable @day:

`GetValue(Split(GetValue(Split(GetValue(Split(Now("Europe/Madrid"),"."),0)," "),0),"-"),2)`

To get the variable @month:

`GetValue(Split(GetValue(Split(GetValue(Split(Now("Europe/Madrid"),"."),0)," "),0),"-"),1)`

To get the variable @year:

`GetValue(Split(GetValue(Split(GetValue(Split(Now("Europe/Madrid"),"."),0)," "),0),"-"),0)`

And finally joining those variables using a Set Variable block:

##### Get Date (DD-MM-YYYY format) and Time (in HH:MM:ss)

If you want to add the time also, will be the same path as before (Get Date (DD-MM-YYYY format), but this time we will add a fourth formula, and add it to the Set Variable block

`GetValue(Split(GetValue(Split(Now("Europe/Madrid"),"."),0)," "),1)`

And the Set Variable block:

#### Today

##### Get current date
`Today()`

To add days to today's date, and then separate year, month and day into different variables in order to configure the desired date format use the following template

#### ToDate

##### Convert date to a format like this 2020-12-20

`ToDate(@dates,"%Y-%m-%d")`