Date

Populating Text field with a Date

To populate a Text field with a Date value from your monday.com board, follow these steps:

  • In Eledo editor click on a Text field and configuration window will appear.
  • Click into Data (expression) field to open Data Expression builder.
  • Find and select a Date Column using the Fields navigation menu. Start with the item and continue with date.
  • If you need to print date in different date format, follow instructions below.
  • Confirm twice and you're done!

image

Formatting Dates:

Date Format

Format the date value into a specific date format with DATE function. Date format consists of case sensitive letters with various meanings. This function depends on Timezone and Locale setting of your template.

DATE(value, date_format)

Example:

item.date = 14. July 2025

DATE(item.date, "MM/dd/yyyy") Output: 07/14/2025

DATE(item.date, "dd/MM/yyyy") Output: 14/07/2025

DATE(item.date, "EEEE, MMMM d, yyyy") Output: Monday, July 14, 2025

DATE(item.date, "dd MMMM yyyy") Output: 14 July 2025

Date formatting letters are listed in this article: Formatting Dates

Tips:

TODAY() = Prints today's date

DATE(TODAY(), "yyyy-MM-dd")

item.date = 1. January 2025 ; item.date_1 = 20. January 2025

DAYS_BETWEEN(item.date, item.date_1) Output: 19

Find more information about data formatting in this article: Formatting Dates

Discover all date functions here: Date Functions


Was this article helpful?

Yes

No