Logo
For example "scheduled tasks"
Search
Info
Content
Category Navigation
  • 📖  Manual

  • 👋Welcome

    Welcome to Tadabase

    What Is No-Code?

    Tadabase Support

    Getting Started With Tadabase

    Platform Overview

    🧰The Data Builder

    Data Tables

    Fields

    Text Fields

    Personal Fields

    Number Fields

    Date Fields

    Option Fields

    File and Image Fields

    Equation Fields (Category)

    Equation Fields

    Connection Fields

    Date Equation Examples

    Records

    Record Logs

    Import Templates

    Export Templates

    Automating Tasks

    Number Equation Examples

    Text Equation Examples

    Multi-Function Equation Examples

    ✏️Page Builder

    Page Builder Overview

    Layouts

    Pages

    Components Overview

    PDF Pages (Alpha)

    PDF Pages 2.0

    📗System Components

    System Components Overview

    Menu

    User Menu

    Breadcrumbs

    PDF Print (Alpha)

    Link Button

    Login

    Signup

    Profile

    HTML

    Image

    Subscriptions (Alpha)

    📘Data Components

    Data Components Overview

    Form Component

    Table Component

    List Component

    Kanban Component

    Calendar Component

    Resource Component

    Map Component

    Timeline Component

    Accordion Component

    Card Component

    Chart Component

    Search Component

    Import Component

    Data Source

    Data Source Filtering

    Links

    Display Rules

    Inline Editing

    Data Component Visual Directory

    Custom Component

    Custom Component Helpers

    Writing Your Own Component Helpers

    🙋Users

    Users

    Roles

    Single Sign On (SSO)

    Adding Stripe Subscriptions

    🔒Security and Reliability

    Tadabase Builder Security

    App Security

    User Security

    🔗Integrations

    Zapier Integration

    Using Webhooks

    Saving files to Dropbox

    Adding PayPal payment buttons to your app

    Exporting records to Google Sheets

    Viewing data in Microsoft BI

    Chat Widgets

    REST API

    Using SendGrid for emails

    Saving files to AWS S3 Bucket (IAM Method)

    Incoming Webhooks

    Embeddable Components

    Saving Files to Custom S3 Bucket (Account Method, Recommended)

    PDF Forms

    Stripe Checkout

    JavaScript Callbacks and Actions

    Twilio Integration

    ⚙App Settings

    General Settings

    Layout & Format Settings

    Custom Domain

    Customizing CSS

    Changing app themes

    Support Settings

    404 Error Page

    💳Account

    Plans

    Managing Your Account

    Sharing your app builder

    Managing your Apps

    🧩Pipes

    Introduction to Pipes

    Adding Pipes

    Using Pipes

    PDF Gen V2

Categories
📖 Manual
🧰 The Data Builder
Date Equation Examples

Date Equation Examples

Listed below are several examples of date equations demonstrating date functions in action.

DAYOFMONTH

The DAYOFMONTH function generates the day number of the month given a date value. 

Below is a sample equation using the DAYOFMONTH function.

2022-01-20_13-48-52.png

Below are the results of this sample equation using the DAYOFMONTH function.

YMUuQQtPr2kSpkmrCxLBXTBteMe_IOj6QQ.png

 

DAYOFWEEK

The DAYOFWEEK function generates a numeric representation for the day of the week that the given date falls on. The generated value will be a number from 1-7 where 1 is Sunday and 7 is Saturday.

Below is a sample equation using the DAYOFWEEK function.

2022-01-20_13-50-20.png

Below are the results of this sample equation using the DAYOFWEEK function.

JcomyXsKCxZ-IeWk2Onkt3gu8DS3U3P73w.png

 

DAYOFYEAR

The DAYOFYEAR function generates a numeric representation for the day of the year which the given date falls on. The generated value will be a number from 1-366.

Below is a sample equation using the DAYOFYEAR function.

2022-01-20_13-51-39.png

Below are the results of this sample equation using the DAYOFYEAR function.

EKpnrWbzgefM0kYfvbzh8n5T9VSgw25C9Q.png

DATEDIFF

The DATEDIFF function generates the total amount of days in between the given date values.

Below is a sample equation using the DATEDIFF function, where we get the number of days between the start and end of a Date Range field: 

DATEDIFF({Date Range - End Date},{Date Range - Start Date})+1

LAST_DAY

The LAST_DAY function generates the last date of the month of the given date value. The generated value will be a date format.

Below is a sample equation using the LAST_DAY function.

2022-01-20_13-53-23.png

this sample equation using the LAST_DAY function.

X134eISmxfLyNA5sFaDrpz0_dKG3n0AMTA.png

 

YEAR

The YEAR function generates the year of the given date. The output will be a single numeric representation of the year value.

Below is a sample equation using the YEAR function.

2022-01-20_14-46-10.png

Below are the results of this sample equation using the YEAR function.

BK9JuC6QR4q7Ovi9rNShG1GufawGtGBIdg.png

 

MONTH

The MONTH function generates the month of the given date within its numeric value. The output will be a single numeric representation of the month value.

Below is a sample equation using the MONTH function.

2022-01-20_14-47-30.png

Below are the results of this sample equation using the MONTH function.

4dOFT_KQmaM7tNM8p0Ej3WSzno5R0fawug.png

 

MONTHNAME

The MONTHNAME function generates the name of the month of the given date. The output will be a text representation of the month value.

Below is a sample equation using the MONTHNAME function.

2022-01-20_14-48-36.png

Below are the results of this sample equation using the MONTHNAME function.

s_WgQ5tGuiIa4XnnivSYXIWHM9L60_U2kw.png

 

NOW

The NOW function generates the current time. This function, unlike the other Date Functions, is not to be used with any fields as input (as illustrated in the image below). The value is saved upon record creation and updated upon saving any type of edit.

Below is a sample equation using the NOW function.

2022-01-20_14-49-31.png

Below are the results of this sample equation using the NOW function.

cJTM1rSnDt7xe1Gcasq-RBIGzbiZ4d09Ag.png

 

WEEKOFYEAR

The WEEKOFYEAR function generates the week number that the given date falls within. The output will be a single numeric representation of the week.

Below is a sample equation using the WEEKOFYEAR function.

2022-01-20_14-50-29.png

Below are the results of this sample equation using the WEEKOFYEAR function.

RhWVA8Dt384NOwQgFf9VbemKX7ZhvMGOoA.png

How did we do ?

Previous Article
Connection Fields
Next Article
Records
Article Navigation
  • DAYOFMONTH
  • DAYOFWEEK
  • DAYOFYEAR
  • DATEDIFF
  • LAST_DAY
  • YEAR
  • MONTH
  • MONTHNAME
  • NOW
  • WEEKOFYEAR
  • Back to top
    API
    100% Operational
    Apps
    100% Operational
    Builder
    100% Operational
    Overall Status
    100% Operational