Date
Get the current date and time, add or subtract days, compute differences, read parts of a date, format and convert between dates, timestamps, epochs, ISO texts and time zones. Other functions give the first and last day of a period, business days, Easter, the next run of a cron expression and durations. Typical uses: compute a due date, group sales by week or quarter.
date adddate addtdate current_msdate current_nsdate curdatedate current_datedate current_timedate current_timestampdate curtimedate curtimestampdate dateadddate dateaddtdate datediffdate datedifftdate ts_to_longdate dt_to_longdate long_to_dtdate long_to_tsdate day_of_monthdate day_of_weekdate day_of_yeardate daynamedate daynamedate diffdate difftdate full_systimestampdate hourdate is_valid_datedate is_valid_datedate is_valid_timedate is_valid_timestampdate is_valid_timestampdate formatdate minutedate monthdate monthnamedate monthnamedate nb_daydate secondedate sysdatedate systimedate systimestampdate nowdate systimestamp_mindate timedate yeardate epochdate timezonedate systimestamp_utcdate first_day_of_monthdate last_day_of_monthdate first_day_of_yeardate last_day_of_yeardate first_day_of_weekdate last_day_of_weekdate week_of_yeardate quarterdate is_leap_yeardate days_in_monthdate is_weekenddate agedate to_isodate from_isodate to_epochdate from_epochdate to_utcdate from_utcdate next_daydate add_business_daysdate nb_business_daysdate is_beforedate is_afterdate truncdate durationdate betweendate convert_tzdate easterdate holidays_frdate holidays_frdate is_holiday_frdate is_holiday_frdate add_business_days_frdate add_business_days_frdate business_days_frdate business_days_frdate iso_weekdate cron_nextdate cron_nextdate duration_parsedate duration_formatdate overlap

date add <date> <field> <number>


Description

    Add a number to a date.

Parameters

    date:   The date - String - required
    field:   The field to add (DAY|MONTH|YEAR) - String - required
    number:   The number to add - Number - required
admin
date add "1980-06-18" "DAY" 1
mentdb
1980-06-19
Used in use cases (15 recipes)

    Date & time developer › Support ticket SLA in business days
    Climate & environment scientist › Amplitude and phase of the annual temperature cycle
    IoT & sensor engineer › Battery life of a LoRaWAN sensor node
    System administrator & DevOps › When will the disk be full?
    Accountant & manager › Invoice totals with two VAT rates and the due date
    HR & payroll › Age, seniority and next long-service award
    and 9 more in the Use cases
Often used with

    date is_weekend  ·  atom get  ·  date is_after  ·  date nb_business_days  ·  date nb_day  ·  date add_business_days  ·  date day_of_week  ·  math floor

date addt <timestamp> <field> <number>


Description

    Add a number to a timestamp.

Parameters

    timestamp:   The timestamp - String - required
    field:   The field to add (SEC|MIN|HOUR|DAY|MONTH|YEAR) - String - required
    number:   The number to add - Number - required
admin
date addt "1980-06-18 00:00:00" "DAY" 1
mentdb
1980-06-19 00:00:00
Used in use cases (2 recipes)

    Date & time developer › Batch window from a legacy file header
    Screen & UI developer (sajax) › Modal booking form with date, datetime, time and number pickers
Often used with

    date format  ·  string left  ·  concat_var  ·  date dateadd  ·  date dateaddt  ·  date datediff  ·  date datedifft  ·  date diff

date current_ms


Description

    Returns the current time in milliseconds.

admin
date current_ms
mentdb
1496164604097
Used in use cases (15 recipes)

    MQL developer › Cache a slow result in a node with a TTL
    Backend & web service developer › Health check endpoint for the load balancer
    Date & time developer › Run log header and execution timer
    JSON & document store developer › A report cached in a node with a time to live
    Debugging & error handling › Follow an order through the logs with a correlation id
    Algorithms in MQL › Bubble sort and insertion sort against json sort
    and 9 more in the Use cases
Often used with

    execute  ·  script create  ·  script delete  ·  and  ·  while  ·  date now  ·  date sysdate  ·  node create

date current_ns


Description

    Returns the current time in nanoseconds.

admin
date current_ns
mentdb
823603146305304
Used in use cases (1 recipe)

    Date & time developer › Run log header and execution timer
Often used with

    date add  ·  date age  ·  date curdate  ·  date current_date  ·  date current_ms  ·  date current_time  ·  date current_timestamp  ·  date curtime

date curdate


Description

    Returns the current date.

admin
date curdate
mentdb
2015-09-13
Used in use cases (4 recipes)

    Date & time developer › Run log header and execution timer
    Screen & UI developer (sajax) › Bootstrap page skeleton with an onload call
    Files & archives manager › Store a base64 attachment, check it, read it, archive it
    Screen & UI developer (sajax) › Approve button: refresh, alert and JavaScript from one action
Often used with

    concat_var  ·  include  ·  string decode_b64  ·  atom get  ·  case  ·  date add  ·  date age  ·  date current_date

date current_date


Description

    Returns the current date.

admin
date current_date
mentdb
2015-09-13
Used in use cases (1 recipe)

    Date & time developer › Run log header and execution timer
Often used with

    date add  ·  date age  ·  date curdate  ·  date current_ms  ·  date current_ns  ·  date current_time  ·  date current_timestamp  ·  date curtime

date current_time


Description

    Returns the current time.

admin
date current_time
mentdb
14:01:22
Used in use cases (1 recipe)

    Date & time developer › Run log header and execution timer
Often used with

    date add  ·  date age  ·  date curdate  ·  date current_date  ·  date current_ms  ·  date current_ns  ·  date current_timestamp  ·  date curtime

date current_timestamp


Description

    Returns the current timestamp.

admin
date current_timestamp
mentdb
2015-09-13 14:01:42
Used in use cases (1 recipe)

    Date & time developer › Run log header and execution timer
Often used with

    date add  ·  date age  ·  date curdate  ·  date current_date  ·  date current_ms  ·  date current_ns  ·  date current_time  ·  date curtime

date curtime


Description

    Returns the current time.

admin
date curtime
mentdb
14:01:57
Used in use cases (1 recipe)

    Date & time developer › Run log header and execution timer
Often used with

    date add  ·  date age  ·  date curdate  ·  date current_date  ·  date current_ms  ·  date current_ns  ·  date current_time  ·  date current_timestamp

date curtimestamp


Description

    Returns the current timestamp.

admin
date curtimestamp
mentdb
2015-09-13 14:02:13
Used in use cases (1 recipe)

    Date & time developer › Run log header and execution timer
Often used with

    date add  ·  date age  ·  date curdate  ·  date current_date  ·  date current_ms  ·  date current_ns  ·  date current_time  ·  date current_timestamp

date dateadd <date> <field> <number>


Description

    Add a number to a date.

Parameters

    date:   The date - String - required
    field:   The field to add (DAY|MONTH|YEAR) - String - required
    number:   The number to add - Number - required
admin
date dateadd "1980-06-18" "DAY" 1
mentdb
1980-06-19
Used in use cases (2 recipes)

    Date & time developer › Batch window from a legacy file header
    Async developer › Dashboard of the stack queue
Often used with

    date addt  ·  date dateaddt  ·  date datediff  ·  date datedifft  ·  date diff  ·  date difft  ·  date format  ·  date hour

date dateaddt <timestamp> <field> <number>


Description

    Add a number to a timestamp.

Parameters

    timestamp:   The timestamp - String - required
    field:   The field to add (SEC|MIN|HOUR|DAY|MONTH|YEAR) - String - required
    number:   The number to add - Number - required
admin
date dateaddt "1980-06-18 00:00:00" "DAY" 1
mentdb
1980-06-19 00:00:00
Used in use cases (14 recipes)

    Date & time developer › Batch window from a legacy file header
    Async developer › Plan reminders at J+7, J+15 and J+30, then cancel them
    Scheduler developer › Prove a job ran with the log table
    Event developer › Run a script when a file arrives in a folder
    Async developer › Priorities and parallel limit of the stack
    Async developer › A run fails, the API comes back, replay it
    and 8 more in the Use cases
Often used with

    date now  ·  script create  ·  script delete  ·  string substring  ·  wait  ·  while  ·  and  ·  sequence add

date datediff <date> <field> <number>


Description

    Subtract a number from a date.

Parameters

    date:   The date - String - required
    field:   The field to add (DAY|MONTH|YEAR) - String - required
    number:   The number to add - Number - required
admin
date datediff "1980-06-18" "DAY" 1
mentdb
1980-06-17
Used in use cases (2 recipes)

    Date & time developer › Batch window from a legacy file header
    Files & archives manager › Retention policy: purge the daily exports older than 30 days
Often used with

    date format  ·  date addt  ·  date dateadd  ·  date dateaddt  ·  date datedifft  ·  date diff  ·  date difft  ·  date first_day_of_month

date datedifft <timestamp> <field> <number>


Description

    Subtract a number from a date.

Parameters

    timestamp:   The timestamp - String - required
    field:   The field to add (SEC|MIN|HOUR|DAY|MONTH|YEAR) - String - required
    number:   The number to add - Number - required
admin
date datedifft "1980-06-18 00:00:00" "DAY" 1
mentdb
1980-06-17 00:00:00
Used in use cases (2 recipes)

    Date & time developer › Batch window from a legacy file header
    Automation architect › Retry the failed runs of a worker
Often used with

    date addt  ·  date dateadd  ·  date dateaddt  ·  date datediff  ·  date diff  ·  date difft  ·  date format  ·  date hour

date ts_to_long <timestamp>


Description

    Converts a timestamp to a long int.

Parameters

    timestamp:   The timestamp - String - required
admin
date ts_to_long "1980-06-18 00:00:00"
mentdb
330120000000
Used in use cases (1 recipe)

    Date & time developer › Time zones, ISO 8601 and epoch for an API
Often used with

    date convert_tz  ·  date dt_to_long  ·  date from_epoch  ·  date from_iso  ·  date from_utc  ·  date long_to_dt  ·  date long_to_ts  ·  date timezone

date dt_to_long <date>


Description

    Converts the date parameter to a long int.

Parameters

    date:   The date - String - required
admin
date dt_to_long "1980-06-18"
mentdb
330120000000
Used in use cases (1 recipe)

    Date & time developer › Time zones, ISO 8601 and epoch for an API
Often used with

    date convert_tz  ·  date from_epoch  ·  date from_iso  ·  date from_utc  ·  date long_to_dt  ·  date long_to_ts  ·  date timezone  ·  date to_epoch

date long_to_dt <date>


Description

    Converts the date parameter sent by the user to a long int.

Parameters

    date:   The date - String - required
admin
date long_to_dt "330120000000"
mentdb
1980-06-18
Used in use cases (1 recipe)

    Date & time developer › Time zones, ISO 8601 and epoch for an API
Often used with

    date convert_tz  ·  date dt_to_long  ·  date from_epoch  ·  date from_iso  ·  date from_utc  ·  date long_to_ts  ·  date timezone  ·  date to_epoch

date long_to_ts <date>


Description

    Converts a long int to a timestamp.

Parameters

    date:   The date - String - required
admin
date long_to_ts "330120000000"
mentdb
1980-06-18 00:00:00
Used in use cases (2 recipes)

    MQL developer › Sort CSV columns: text sort versus numeric sorts
    Date & time developer › Time zones, ISO 8601 and epoch for an API
Often used with

    atom distinct  ·  atom size  ·  date convert_tz  ·  date dt_to_long  ·  date from_epoch  ·  date from_iso  ·  date from_utc  ·  date long_to_dt

date day_of_month <date>


Description

    Returns the day specified in the date sent in parameter.

Parameters

    date:   The date - String - required
admin
date day_of_month "1980-06-18"
mentdb
18
Used in use cases (3 recipes)

    Date & time developer › One row of a date dimension table
    XML, HTML & Word integrator › RSS feed to an HTML news digest
    Date & time developer › Monthly billing dates and proration of an upgrade
Often used with

    date day_of_week  ·  date days_in_month  ·  date first_day_of_month  ·  date is_leap_year  ·  date monthname  ·  date nb_day  ·  atom get  ·  date add

date day_of_week <date>


Description

    Returns the week value of the date sent as parameter.

Parameters

    date:   The date - String - required
admin
date day_of_week "1980-06-18"
mentdb
3
Used in use cases (7 recipes)

    Date & time developer › One row of a date dimension table
    Scheduler developer › A frequent job that works only in business hours
    HR & payroll › Overtime pay by ISO week
    Sales & marketing analyst › Best send time of a newsletter
    Date & time developer › Monthly billing dates and proration of an upgrade
    Date & time developer › Is the shop open now, and when does it open next
    and 1 more in the Use cases
Often used with

    date add  ·  json doc  ·  string left  ·  and  ·  atom get  ·  date day_of_month  ·  date days_in_month  ·  date first_day_of_month

date day_of_year <date>


Description

    Returns the year value of the date sent as parameter.

Parameters

    date:   The date - String - required
admin
date day_of_year "1980-06-18"
mentdb
170
Used in use cases (3 recipes)

    Date & time developer › One row of a date dimension table
    Astronomer › Sunrise, sunset and equation of time at the winter solstice
    Renewable energy engineer › Sun angles and plane of array irradiance on a tilted PV panel
Often used with

    math deg_to_rad  ·  math rad_to_deg  ·  date day_of_month  ·  date day_of_week  ·  date dayname  ·  date days_in_month  ·  date first_day_of_month  ·  date first_day_of_week

date dayname <date>


Description

    Returns the day name of the date sent as parameter, in the language of the server (use the form with a language for the same result on every server).

Parameters

    date:   The date - String - required
admin
date dayname "1980-06-18"
mentdb
mercredi (on a French server)

date dayname <date> <language>


Description

    Returns the day name of the date in a language (en, fr, es, de, pt-BR...).

Parameters

    date:   The date - String - required
    language:   The language (en, fr, es, de, pt-BR...) - String - required
admin
date dayname "1980-06-18" "en"
mentdb
Wednesday
admin
date dayname "1980-06-18" "fr"
mentdb
mercredi
Used in use cases (5 recipes)

    Date & time developer › Support ticket SLA in business days
    Astronomer › Sunrise, sunset and equation of time at the winter solstice
    XML, HTML & Word integrator › RSS feed to an HTML news digest
    System administrator & DevOps › Do the logs cover the metric window?
    Sales & marketing analyst › Best send time of a newsletter
Often used with

    date is_after  ·  date nb_business_days  ·  date add  ·  date add_business_days  ·  date between  ·  date day_of_month  ·  date day_of_week  ·  date day_of_year

date diff <date> <field> <number>


Description

    Subtract a number from a date.

Parameters

    date:   The date - String - required
    field:   The field to add (DAY|MONTH|YEAR) - String - required
    number:   The number to add - Number - required
admin
date diff "1980-06-18" "DAY" 1
mentdb
1980-06-17
Used in use cases (2 recipes)

    Date & time developer › Batch window from a legacy file header
    HR & payroll › Logins, emails and trial period end of new hires
Often used with

    string left  ·  date add  ·  date addt  ·  date dateadd  ·  date dateaddt  ·  date datediff  ·  date datedifft  ·  date day_of_week

date difft <timestamp> <field> <number>


Description

    Subtract a number from a timestamp.

Parameters

    timestamp:   The timestamp - String - required
    field:   The field to add (SEC|MIN|HOUR|DAY|MONTH|YEAR) - String - required
    number:   The number to add - Number - required
admin
date difft "1980-06-18 00:00:00" "DAY" 1
mentdb
1980-06-17 00:00:00
Used in use cases (1 recipe)

    Date & time developer › Batch window from a legacy file header
Often used with

    date addt  ·  date dateadd  ·  date dateaddt  ·  date datediff  ·  date datedifft  ·  date diff  ·  date format  ·  date hour

date full_systimestamp


Description

    Returns the current full timestamp.

admin
date full_systimestamp
mentdb
2015-09-13 14:03:20.395+0400
Used in use cases (1 recipe)

    Date & time developer › Run log header and execution timer
Often used with

    date add  ·  date age  ·  date curdate  ·  date current_date  ·  date current_ms  ·  date current_ns  ·  date current_time  ·  date current_timestamp

date hour <time>


Description

    Returns the hour value of the time sent as parameter.

Parameters

    time:   The time - String - required
admin
date hour "12:15:56"
mentdb
12
Used in use cases (4 recipes)

    Date & time developer › Batch window from a legacy file header
    Script developer › Stack and delay options of a batch script
    Scheduler developer › A frequent job that works only in business hours
    Sales & marketing analyst › Best send time of a newsletter
Often used with

    date day_of_week  ·  date systime  ·  date time  ·  script create  ·  script delete  ·  string left  ·  string regexp_replace  ·  and

date is_valid_date <dateToValidate>


Description

    Check if a date is valid.

Parameters

    dateToValidate:   The date - String - required
admin
date is_valid_date "1980-06-18"
mentdb
1

date is_valid_date <dateToValidate> <format>


Description

    Check if a date is valid.

Parameters

    dateToValidate:   The date - String - required
    format:   The date format - String - required
admin
date is_valid_date "1980-06-18" "yyyy-MM-dd"
mentdb
1
Used in use cases (1 recipe)

    Date & time developer › Batch window from a legacy file header
Often used with

    date addt  ·  date dateadd  ·  date dateaddt  ·  date datediff  ·  date datedifft  ·  date diff  ·  date difft  ·  date format

date is_valid_time <timeToValidate>


Description

    Check if a time is valid.

Parameters

    timeToValidate:   The time (12:00:01) - String - required
admin
date is_valid_time "12:00:01"
mentdb
1
Used in use cases (1 recipe)

    Date & time developer › Batch window from a legacy file header
Often used with

    date addt  ·  date dateadd  ·  date dateaddt  ·  date datediff  ·  date datedifft  ·  date diff  ·  date difft  ·  date format

date is_valid_timestamp <timestampToValidate>


Description

    Check if a timestamp is valid.

Parameters

    timestampToValidate:   The timestamp - String - required
admin
date is_valid_timestamp "1980-06-18 12:00:01"
mentdb
1

date is_valid_timestamp <timestampToValidate> <format>


Description

    Check if a timestamp is valid.

Parameters

    timestampToValidate:   The timestamp - String - required
    format:   The format (ex: yyyy MM dd HH:mm:ss) - String - required
admin
date is_valid_timestamp "1980-06-18 12:00:01" "yyyy-MM-dd HH:mm:ss"
mentdb
1
Used in use cases (1 recipe)

    Date & time developer › Batch window from a legacy file header
Often used with

    date addt  ·  date dateadd  ·  date dateaddt  ·  date datediff  ·  date datedifft  ·  date diff  ·  date difft  ·  date format

date format <timestampToFormat> <formatIn> <formatOut>


Description

    Convert a timestamp to another format.

Parameters

    timestampToFormat:   The timestamp - String - required
    formatIn:   The in format (ex: yyyyMMdd HH:mm) - String - required
    formatOut:   The out format (ex: yyyy MM dd HH:mm:ss) - String - required
admin
date format "19800618 12:00" "yyyyMMdd HH:mm" "yyyy-MM-dd HH:mm:ss"
mentdb
1980-06-18 12:00:01
Used in use cases (8 recipes)

    Backend & web service developer › Bulk import endpoint with a line by line report
    Date & time developer › One row of a date dimension table
    String & encoding developer › Mail merge: fill a template from JSON data
    JSON & document store developer › Build an order document and its ETag
    Screen & UI developer (sajax) › Modal booking form with date, datetime, time and number pickers
    Files & archives manager › Retention policy: purge the daily exports older than 30 days
    and 2 more in the Use cases
Often used with

    json doc  ·  json uobject  ·  string left  ·  string trim  ·  date addt  ·  date datediff  ·  date first_day_of_month  ·  date last_day_of_month

date minute <time>


Description

    Returns the minute value of the time sent as parameter.

Parameters

    time:   The time - String - required
admin
date minute "12:15:56"
mentdb
15
Used in use cases (1 recipe)

    Date & time developer › Batch window from a legacy file header
Often used with

    date addt  ·  date dateadd  ·  date dateaddt  ·  date datediff  ·  date datedifft  ·  date diff  ·  date difft  ·  date format

date month <date>


Description

    Returns the month value of a date sent as parameter.

Parameters

    date:   The date - String - required
admin
date month "1980-06-18"
mentdb
6
Used in use cases (3 recipes)

    Date & time developer › One row of a date dimension table
    HR & payroll › Leave request and balance
    Date & time developer › GDPR retention: keep, anonymise or delete customers
Often used with

    date add  ·  date first_day_of_month  ·  date nb_day  ·  date quarter  ·  atom count  ·  case  ·  date day_of_month  ·  date day_of_week

date monthname <date>


Description

    Returns the month name of the date sent as parameter, in the language of the server (use the form with a language for the same result on every server).

Parameters

    date:   The date - String - required
admin
date monthname "1980-06-18"
mentdb
juin (on a French server)

date monthname <date> <language>


Description

    Returns the month name of the date in a language (en, fr, es, de, pt-BR...).

Parameters

    date:   The date - String - required
    language:   The language (en, fr, es, de, pt-BR...) - String - required
admin
date monthname "1980-06-18" "en"
mentdb
June
admin
date monthname "1980-06-18" "fr"
mentdb
juin
Used in use cases (2 recipes)

    Date & time developer › One row of a date dimension table
    XML, HTML & Word integrator › RSS feed to an HTML news digest
Often used with

    date day_of_month  ·  date day_of_week  ·  date day_of_year  ·  date dayname  ·  date days_in_month  ·  date first_day_of_month  ·  date first_day_of_week  ·  date first_day_of_year

date nb_day <date1> <date2>


Description

    Get the number of days between two dates

Parameters

    date1:   The date 1 - String - required
    date2:   The date 2 - String - required
admin
date nb_day "1980-06-18" "1980-06-20"
mentdb
2
Used in use cases (15 recipes)

    Date & time developer › One row of a date dimension table
    Data validation developer › Cross-field rules of a hotel booking
    Nuclear & radiation physicist › Activity of a check source today
    Climate & environment scientist › Amplitude and phase of the annual temperature cycle
    Files & archives manager › Retention policy: purge the daily exports older than 30 days
    System administrator & DevOps › Do the logs cover the metric window?
    and 9 more in the Use cases
Often used with

    json doc  ·  atom get  ·  date add  ·  date first_day_of_month  ·  json iarray  ·  string regexp_replace  ·  bd+  ·  date is_after

date seconde <time>


Description

    Returns the second value of the time sent as parameter.

Parameters

    time:   The time - String - required
admin
date seconde "12:15:56"
mentdb
56
Used in use cases (1 recipe)

    Date & time developer › Batch window from a legacy file header
Often used with

    date addt  ·  date dateadd  ·  date dateaddt  ·  date datediff  ·  date datedifft  ·  date diff  ·  date difft  ·  date format

date sysdate


Description

    Returns the current date.

admin
date sysdate
mentdb
2015-09-13
Used in use cases (21 recipes)

    MQL beginner › Your first web service, called with execute
    Backend & web service developer › Read server parameters and trace a run in the logs
    Date & time developer › Run log header and execution timer
    Web service developer › DELETE: idempotent delete with an audit trail
    Async developer › Dashboard of the stack queue
    Scheduler developer › A frequent job that works only in business hours
    and 15 more in the Use cases
Often used with

    script create  ·  log write  ·  execute  ·  script delete  ·  string substring  ·  cm get  ·  log search  ·  string regexp_extract

date systime


Description

    Returns the current time.

admin
date systime
mentdb
14:04:18
Used in use cases (4 recipes)

    Date & time developer › Run log header and execution timer
    Script developer › Stack and delay options of a batch script
    Execution modes › Stack run postponed until a gate opens
    Scheduler developer › A frequent job that works only in business hours
Often used with

    date now  ·  script create  ·  script delete  ·  and  ·  date hour  ·  date is_weekend  ·  date sysdate  ·  date systimestamp

date systimestamp


Description

    Returns the current timestamp.

admin
date systimestamp
mentdb
2015-09-13 14:04:32
Used in use cases (8 recipes)

    Date & time developer › Run log header and execution timer
    Execution modes › Stack run postponed until a gate opens
    File transfer & remote systems engineer › Watch a drop folder, push files over SSH and notify the head office
    API & database integrator › Notify an internal HTTP webhook with a JSON event
    Integrator & ETL developer › Nightly copy of an Oracle table into MySQL, committed by batches
    System administrator & DevOps › Health report in JSON for the monitoring
    and 2 more in the Use cases
Often used with

    json doc  ·  json iobject  ·  parameter get value  ·  cm get  ·  date now  ·  date sysdate  ·  date systime  ·  execute

date now


Description

    Returns the current timestamp.

admin
date now
mentdb
2015-09-13 14:04:32
Used in use cases (29 recipes)

    MQL developer › Cache a slow result in a node with a TTL
    Backend & web service developer › Signed webhook receiver with replay protection
    Date & time developer › Run log header and execution timer
    Execution modes › Stack run postponed until a gate opens
    Async developer › Push a script to the stack and watch it close
    Scheduler developer › Prove a job ran with the log table
    and 23 more in the Use cases
Often used with

    script create  ·  script delete  ·  and  ·  wait  ·  while  ·  sequence add  ·  sequence remove  ·  stack

date systimestamp_min


Description

    Returns the current timestamp in minimal format.

admin
date systimestamp_min
mentdb
20150913140446
Used in use cases (1 recipe)

    Date & time developer › Run log header and execution timer
Often used with

    date add  ·  date age  ·  date curdate  ·  date current_date  ·  date current_ms  ·  date current_ns  ·  date current_time  ·  date current_timestamp

date time <timestamp>


Description

    Get the time part of a timestamp.

Parameters

    timestamp:   The timestamp - String - required
admin
date time "1980-06-18 12:25:56"
mentdb
12:25:56
Used in use cases (3 recipes)

    Date & time developer › Batch window from a legacy file header
    Sales & marketing analyst › Best send time of a newsletter
    Date & time developer › Is the shop open now, and when does it open next
Often used with

    string left  ·  date day_of_week  ·  date hour  ·  and  ·  atom find  ·  atom get  ·  atom size  ·  date add

date year <date>


Description

    Returns the year value of the date sent as parameter.

Parameters

    date:   The date - String - required
admin
date year "1980-06-18"
mentdb
1980
Used in use cases (2 recipes)

    Date & time developer › One row of a date dimension table
    Climate & environment scientist › Dates of the remaining 1.5 C carbon budget
Often used with

    date add  ·  date day_of_month  ·  date day_of_week  ·  date day_of_year  ·  date days_in_month  ·  date first_day_of_month  ·  date first_day_of_week  ·  date first_day_of_year

date epoch


Description

    Returns the current Unix epoch in seconds.

admin
date epoch
mentdb
1761818400
Used in use cases (1 recipe)

    Date & time developer › Run log header and execution timer
Often used with

    date add  ·  date age  ·  date curdate  ·  date current_date  ·  date current_ms  ·  date current_ns  ·  date current_time  ·  date current_timestamp

date timezone


Description

    Returns the time zone of the server.

admin
date timezone
mentdb
Indian/Reunion
Used in use cases (1 recipe)

    Date & time developer › Time zones, ISO 8601 and epoch for an API
Often used with

    date convert_tz  ·  date dt_to_long  ·  date from_epoch  ·  date from_iso  ·  date from_utc  ·  date long_to_dt  ·  date long_to_ts  ·  date to_epoch

date systimestamp_utc


Description

    Returns the current UTC timestamp.

admin
date systimestamp_utc
mentdb
2026-10-30 10:00:00
Used in use cases (1 recipe)

    Date & time developer › Run log header and execution timer
Often used with

    date add  ·  date age  ·  date curdate  ·  date current_date  ·  date current_ms  ·  date current_ns  ·  date current_time  ·  date current_timestamp

date first_day_of_month <date>


Description

    Returns the first day of the month.

Parameters

    date:   The date or timestamp - String - required
admin
date first_day_of_month "1980-06-18"
mentdb
1980-06-01
Used in use cases (5 recipes)

    Date & time developer › One row of a date dimension table
    Files & archives manager › Retention policy: purge the daily exports older than 30 days
    API & database integrator › IMAP: supplier confirmations only, as JSON, moved to a folder
    Date & time developer › Monthly billing dates and proration of an upgrade
    Date & time developer › GDPR retention: keep, anonymise or delete customers
Often used with

    date nb_day  ·  date add  ·  date day_of_month  ·  date day_of_week  ·  date days_in_month  ·  date format  ·  date is_leap_year  ·  date last_day_of_month

date last_day_of_month <date>


Description

    Returns the last day of the month.

Parameters

    date:   The date or timestamp - String - required
admin
date last_day_of_month "1980-06-18"
mentdb
1980-06-30
Used in use cases (3 recipes)

    Date & time developer › One row of a date dimension table
    Files & archives manager › Retention policy: purge the daily exports older than 30 days
    Accountant & manager › Invoice totals with two VAT rates and the due date
Often used with

    date first_day_of_month  ·  date format  ·  date nb_day  ·  date add  ·  date add_business_days  ·  date datediff  ·  date day_of_month  ·  date day_of_week

date first_day_of_year <date>


Description

    Returns the first day of the year.

Parameters

    date:   The date or timestamp - String - required
admin
date first_day_of_year "1980-06-18"
mentdb
1980-01-01
Used in use cases (1 recipe)

    Date & time developer › One row of a date dimension table
Often used with

    date day_of_month  ·  date day_of_week  ·  date day_of_year  ·  date days_in_month  ·  date first_day_of_month  ·  date first_day_of_week  ·  date format  ·  date is_leap_year

date last_day_of_year <date>


Description

    Returns the last day of the year.

Parameters

    date:   The date or timestamp - String - required
admin
date last_day_of_year "1980-06-18"
mentdb
1980-12-31
Used in use cases (1 recipe)

    Date & time developer › One row of a date dimension table
Often used with

    date day_of_month  ·  date day_of_week  ·  date day_of_year  ·  date days_in_month  ·  date first_day_of_month  ·  date first_day_of_week  ·  date first_day_of_year  ·  date format

date first_day_of_week <date>


Description

    Returns the first day of the ISO week (monday).

Parameters

    date:   The date or timestamp - String - required
admin
date first_day_of_week "1980-06-18"
mentdb
1980-06-16
Used in use cases (2 recipes)

    Date & time developer › One row of a date dimension table
    Date & time developer › Weekly sign-up cohorts and day-14 retention
Often used with

    date nb_day  ·  date week_of_year  ·  json doc  ·  json iobject  ·  atom get  ·  atom size  ·  date day_of_month  ·  date day_of_week

date last_day_of_week <date>


Description

    Returns the last day of the ISO week (sunday).

Parameters

    date:   The date or timestamp - String - required
admin
date last_day_of_week "1980-06-18"
mentdb
1980-06-22
Used in use cases (1 recipe)

    Date & time developer › One row of a date dimension table
Often used with

    date day_of_month  ·  date day_of_week  ·  date day_of_year  ·  date days_in_month  ·  date first_day_of_month  ·  date first_day_of_week  ·  date first_day_of_year  ·  date format

date week_of_year <date>


Description

    Returns the ISO 8601 week number.

Parameters

    date:   The date or timestamp - String - required
admin
date week_of_year "1980-06-18"
mentdb
25
Used in use cases (4 recipes)

    Date & time developer › One row of a date dimension table
    IoT & sensor engineer › Battery life of a LoRaWAN sensor node
    HR & payroll › Overtime pay by ISO week
    Date & time developer › Weekly sign-up cohorts and day-14 retention
Often used with

    json iobject  ·  date day_of_week  ·  date first_day_of_week  ·  date nb_day  ·  json doc  ·  json uobject  ·  atom get  ·  atom size

date quarter <date>


Description

    Returns the quarter (1 to 4).

Parameters

    date:   The date or timestamp - String - required
admin
date quarter "1980-06-18"
mentdb
2
Used in use cases (2 recipes)

    Date & time developer › One row of a date dimension table
    Date & time developer › GDPR retention: keep, anonymise or delete customers
Often used with

    date first_day_of_month  ·  date month  ·  date nb_day  ·  atom count  ·  case  ·  date add  ·  date day_of_month  ·  date day_of_week

date is_leap_year <date>


Description

    Check if the year is a leap year.

Parameters

    date:   The date, timestamp or year - String - required
admin
date is_leap_year "1980-06-18"
mentdb
1
Used in use cases (2 recipes)

    Date & time developer › One row of a date dimension table
    Date & time developer › Monthly billing dates and proration of an upgrade
Often used with

    date day_of_month  ·  date day_of_week  ·  date days_in_month  ·  date first_day_of_month  ·  date nb_day  ·  atom get  ·  date add  ·  date day_of_year

date days_in_month <date>


Description

    Returns the number of days in the month.

Parameters

    date:   The date or timestamp - String - required
admin
date days_in_month "1980-02-18"
mentdb
29
Used in use cases (2 recipes)

    Date & time developer › One row of a date dimension table
    Date & time developer › Monthly billing dates and proration of an upgrade
Often used with

    date day_of_month  ·  date day_of_week  ·  date first_day_of_month  ·  date is_leap_year  ·  date nb_day  ·  atom get  ·  date add  ·  date day_of_year

date is_weekend <date>


Description

    Check if the date is a saturday or a sunday.

Parameters

    date:   The date or timestamp - String - required
admin
date is_weekend "1980-06-21"
mentdb
1
Used in use cases (9 recipes)

    Date & time developer › Support ticket SLA in business days
    Scheduler developer › A frequent job that works only in business hours
    Control flow › First free meeting slot: nested loops, break and continue
    The MQL language in depth › Loops: continue, break, retry with backoff and parallel
    IoT & sensor engineer › Battery life of a LoRaWAN sensor node
    Accountant & manager › Invoice totals with two VAT rates and the due date
    and 3 more in the Use cases
Often used with

    date add  ·  date nb_business_days  ·  atom get  ·  atom size  ·  continue  ·  date add_business_days  ·  atom find  ·  break

date age <birthdate>


Description

    Returns the age in years at the current date.

Parameters

    birthdate:   The date or timestamp - String - required
admin
date age "1980-06-18"
mentdb
46
Used in use cases (1 recipe)

    Date & time developer › Run log header and execution timer
Often used with

    date add  ·  date curdate  ·  date current_date  ·  date current_ms  ·  date current_ns  ·  date current_time  ·  date current_timestamp  ·  date curtime

date to_iso <timestamp>


Description

    Converts a local timestamp to ISO 8601 with the server offset.

Parameters

    timestamp:   The timestamp or date - String - required
admin
date to_iso "1980-06-18 12:00:00"
mentdb
1980-06-18T12:00:00+04:00
Used in use cases (2 recipes)

    Date & time developer › Time zones, ISO 8601 and epoch for an API
    System administrator & DevOps › CMDB record with a hashed host id
Often used with

    date convert_tz  ·  date dt_to_long  ·  date from_epoch  ·  date from_iso  ·  date from_utc  ·  date long_to_dt  ·  date long_to_ts  ·  date systimestamp

date from_iso <iso>


Description

    Converts an ISO 8601 date (with or without offset) to a local timestamp.

Parameters

    iso:   The ISO 8601 date - String - required
admin
date from_iso "1980-06-18T08:00:00Z"
mentdb
1980-06-18 12:00:00
Used in use cases (1 recipe)

    Date & time developer › Time zones, ISO 8601 and epoch for an API
Often used with

    date convert_tz  ·  date dt_to_long  ·  date from_epoch  ·  date from_utc  ·  date long_to_dt  ·  date long_to_ts  ·  date timezone  ·  date to_epoch

date to_epoch <timestamp>


Description

    Converts a local timestamp to a Unix epoch in seconds.

Parameters

    timestamp:   The timestamp or date - String - required
admin
date to_epoch "1980-06-18 12:00:00"
mentdb
330163200
Used in use cases (3 recipes)

    Date & time developer › Time zones, ISO 8601 and epoch for an API
    Astronomer › Julian date, sidereal time and Moon age of an observing night
    XML, HTML & Word integrator › GPS track (GPX): distance, climb and average speed
Often used with

    date from_utc  ·  date convert_tz  ·  date dt_to_long  ·  date duration  ·  date from_epoch  ·  date from_iso  ·  date long_to_dt  ·  date long_to_ts

date from_epoch <epoch>


Description

    Converts a Unix epoch in seconds to a local timestamp.

Parameters

    epoch:   The epoch in seconds - Number - required
admin
date from_epoch "330163200"
mentdb
1980-06-18 12:00:00
Used in use cases (2 recipes)

    Date & time developer › Time zones, ISO 8601 and epoch for an API
    Web & API developer › Decode and build a Snowflake id
Often used with

    date to_utc  ·  bd*  ·  bd+  ·  bigdec div  ·  bigdec round  ·  date convert_tz  ·  date dt_to_long  ·  date from_iso

date to_utc <timestamp>


Description

    Converts a local timestamp to UTC.

Parameters

    timestamp:   The timestamp or date - String - required
admin
date to_utc "1980-06-18 12:00:00"
mentdb
1980-06-18 08:00:00
Used in use cases (2 recipes)

    Date & time developer › Time zones, ISO 8601 and epoch for an API
    Web & API developer › Decode and build a Snowflake id
Often used with

    date from_epoch  ·  bd*  ·  bd+  ·  bigdec div  ·  bigdec round  ·  date convert_tz  ·  date dt_to_long  ·  date from_iso

date from_utc <timestamp>


Description

    Converts a UTC timestamp to local time.

Parameters

    timestamp:   The timestamp or date - String - required
admin
date from_utc "1980-06-18 08:00:00"
mentdb
1980-06-18 12:00:00
Used in use cases (2 recipes)

    Date & time developer › Time zones, ISO 8601 and epoch for an API
    Astronomer › Julian date, sidereal time and Moon age of an observing night
Often used with

    date to_epoch  ·  date convert_tz  ·  date dt_to_long  ·  date from_epoch  ·  date from_iso  ·  date long_to_dt  ·  date long_to_ts  ·  date timezone

date next_day <date> <day>


Description

    Returns the next given day strictly after the date.

Parameters

    date:   The date or timestamp - String - required
    day:   The day (monday ... sunday, lundi ... dimanche, or 1 ... 7) - String - required
admin
date next_day "1980-06-18" "monday"
mentdb
1980-06-23
Used in use cases (2 recipes)

    Date & time developer › Support ticket SLA in business days
    IoT & sensor engineer › Battery life of a LoRaWAN sensor node
Often used with

    date add  ·  date is_weekend  ·  date nb_business_days  ·  date add_business_days  ·  date between  ·  date dayname  ·  date duration  ·  date is_after

date add_business_days <date> <number>


Description

    Add (or subtract if negative) business days (monday to friday).

Parameters

    date:   The date or timestamp - String - required
    number:   The number of business days - Number - required
admin
date add_business_days "1980-06-20" 1
mentdb
1980-06-23
Used in use cases (4 recipes)

    Date & time developer › Support ticket SLA in business days
    Accountant & manager › Invoice totals with two VAT rates and the due date
    Logistics & supply chain › Promised delivery date in business days
    Date & time developer › French public holidays and a delivery date in working days
Often used with

    date add  ·  date is_weekend  ·  date between  ·  atom find  ·  atom get  ·  atom size  ·  continue  ·  date dayname

date nb_business_days <date1> <date2>


Description

    Get the number of business days (monday to friday) in [date1, date2[.

Parameters

    date1:   The date 1 - String - required
    date2:   The date 2 - String - required
admin
date nb_business_days "1980-06-16" "1980-06-23"
mentdb
5
Used in use cases (5 recipes)

    Date & time developer › Support ticket SLA in business days
    IoT & sensor engineer › Battery life of a LoRaWAN sensor node
    System administrator & DevOps › Do the logs cover the metric window?
    HR & payroll › Leave request and balance
    Date & time developer › Run log header and execution timer
Often used with

    date add  ·  date is_weekend  ·  date dayname  ·  date next_day  ·  date add_business_days  ·  date age  ·  date between  ·  date curdate

date is_before <timestamp1> <timestamp2>


Description

    Check if the first date/timestamp is before the second.

Parameters

    timestamp1:   The timestamp or date 1 - String - required
    timestamp2:   The timestamp or date 2 - String - required
admin
date is_before "1980-06-18" "1980-06-20 10:00:00"
mentdb
1
Used in use cases (2 recipes)

    Date & time developer › Support ticket SLA in business days
    Data validation developer › Cross-field rules of a hotel booking
Often used with

    date between  ·  date is_after  ·  and  ·  atom get  ·  atom size  ·  bd+  ·  date add  ·  date add_business_days

date is_after <timestamp1> <timestamp2>


Description

    Check if the first date/timestamp is after the second.

Parameters

    timestamp1:   The timestamp or date 1 - String - required
    timestamp2:   The timestamp or date 2 - String - required
admin
date is_after "1980-06-18" "1980-06-20"
mentdb
0
Used in use cases (7 recipes)

    Date & time developer › Support ticket SLA in business days
    Data validation developer › Cross-field rules of a hotel booking
    XML, HTML & Word integrator › RSS feed to an HTML news digest
    Accountant & manager › Late payment interest and recovery indemnity
    Security engineer › Signed licence key checked offline
    Date & time developer › Is the shop open now, and when does it open next
    and 1 more in the Use cases
Often used with

    date add  ·  atom get  ·  date between  ·  date nb_day  ·  is empty  ·  string left  ·  and  ·  atom size

date trunc <timestamp> <field>


Description

    Truncate a timestamp.

Parameters

    timestamp:   The timestamp or date - String - required
    field:   The field (YEAR|QUARTER|MONTH|WEEK|DAY|HOUR|MIN) - String - required
admin
date trunc "1980-06-18 12:25:56" "MONTH"
mentdb
1980-06-01 00:00:00
Used in use cases (1 recipe)

    Date & time developer › Support ticket SLA in business days
Often used with

    date add  ·  date add_business_days  ·  date between  ·  date dayname  ·  date duration  ·  date is_after  ·  date is_before  ·  date is_weekend

date duration <timestamp1> <timestamp2>


Description

    Get a readable duration between two timestamps.

Parameters

    timestamp1:   The timestamp or date 1 - String - required
    timestamp2:   The timestamp or date 2 - String - required
admin
date duration "1980-06-18 10:00:00" "1980-06-20 12:05:10"
mentdb
2d 2h 5min 10s
Used in use cases (4 recipes)

    Date & time developer › Support ticket SLA in business days
    XML, HTML & Word integrator › GPS track (GPX): distance, climb and average speed
    Integrator & ETL developer › Nightly copy of an Oracle table into MySQL, committed by batches
    Date & time developer › Is the shop open now, and when does it open next
Often used with

    date add  ·  date between  ·  date is_after  ·  string substring  ·  and  ·  atom find  ·  atom get  ·  atom size

date between <timestamp> <min> <max>


Description

    Check if a date/timestamp is between two others (bounds included).

Parameters

    timestamp:   The timestamp or date - String - required
    min:   The min - String - required
    max:   The max - String - required
admin
date between "1980-06-18" "1980-06-01" "1980-06-30"
mentdb
1
Used in use cases (4 recipes)

    Date & time developer › Support ticket SLA in business days
    Data validation developer › Cross-field rules of a hotel booking
    Logistics & supply chain › Promised delivery date in business days
    Date & time developer › Is the shop open now, and when does it open next
Often used with

    date is_after  ·  and  ·  atom get  ·  atom size  ·  date add  ·  date add_business_days  ·  date duration  ·  date is_before

date convert_tz <timestamp> <from> <to>


Description

    Convert a timestamp from a time zone to another (ex: Indian/Reunion, Europe/Paris, UTC, +04:00, LOCAL).

Parameters

    timestamp:   The timestamp or date - String - required
    from:   The source time zone - String - required
    to:   The target time zone - String - required
admin
date convert_tz "1980-06-18 12:00:00" "Indian/Reunion" "Europe/Paris"
mentdb
1980-06-18 10:00:00
Used in use cases (1 recipe)

    Date & time developer › Time zones, ISO 8601 and epoch for an API
Often used with

    date dt_to_long  ·  date from_epoch  ·  date from_iso  ·  date from_utc  ·  date long_to_dt  ·  date long_to_ts  ·  date timezone  ·  date to_epoch

date easter <year>


Description

    Date of Easter Sunday of a year (Gregorian calendar)

Parameters

    year:   The year (1583 to 9999) - Number - required
admin
date easter 2027
mentdb
2027-03-28

date holidays_fr <year>


Description

    French public holidays of a year with their name and their day of the week

Parameters

    year:   The year - Number - required
admin
date holidays_fr 2026
mentdb
[{"date": "2026-01-01", "name": "Jour de l'an", "day": "thursday"}, {"date": "2026-04-06", "name": "Lundi de Pâques", "day": "monday"}, {"date": "2026-05-01", "name": "Fête du travail", "day": "friday"}, {"date": "2026-05-08", "name": "Victoire 1945", "day": "friday"}, {"date": "2026-05-14", "name": "Ascension", "day": "thursday"}, {"date": "2026-05-25", "name": "Lundi de Pentecôte", "day": "monday"}, {"date": "2026-07-14", "name": "Fête nationale", "day": "tuesday"}, {"date": "2026-08-15", "name": "Assomption", "day": "saturday"}, {"date": "2026-11-01", "name": "Toussaint", "day": "sunday"}, {"date": "2026-11-11", "name": "Armistice 1918", "day": "wednesday"}, {"date": "2026-12-25", "name": "Noël", "day": "friday"}]

date holidays_fr <year> <region>


Description

    French public holidays of a region: alsace (Alsace-Moselle: + Good Friday and 26 December)

Parameters

    year:   The year - Number - required
    region:   alsace - String - required
admin
date holidays_fr 2026 "alsace"
mentdb
[{"date": "2026-01-01", "name": "Jour de l'an", "day": "thursday"}, {"date": "2026-04-03", "name": "Vendredi saint", "day": "friday"}, {"date": "2026-04-06", "name": "Lundi de Pâques", "day": "monday"}, {"date": "2026-05-01", "name": "Fête du travail", "day": "friday"}, {"date": "2026-05-08", "name": "Victoire 1945", "day": "friday"}, {"date": "2026-05-14", "name": "Ascension", "day": "thursday"}, {"date": "2026-05-25", "name": "Lundi de Pentecôte", "day": "monday"}, {"date": "2026-07-14", "name": "Fête nationale", "day": "tuesday"}, {"date": "2026-08-15", "name": "Assomption", "day": "saturday"}, {"date": "2026-11-01", "name": "Toussaint", "day": "sunday"}, {"date": "2026-11-11", "name": "Armistice 1918", "day": "wednesday"}, {"date": "2026-12-25", "name": "Noël", "day": "friday"}, {"date": "2026-12-26", "name": "Saint Étienne", "day": "saturday"}]

date is_holiday_fr <date>


Description

    Check if a date is a French public holiday (1 or 0)

Parameters

    date:   The date yyyy-MM-dd - String - required
admin
date is_holiday_fr "2026-05-14"
mentdb
1

date is_holiday_fr <date> <region>


Description

    Check if a date is a public holiday in a region (alsace)

Parameters

    date:   The date - String - required
    region:   alsace - String - required
admin
date is_holiday_fr "2026-04-03" "alsace"
mentdb
1
Used in use cases (1 recipe)

    Integrator & ETL developer › Check a job schedule
Often used with

    date cron_next  ·  date duration_format  ·  date duration_parse  ·  date iso_week

date add_business_days_fr <date> <n>


Description

    Add business days (Monday to Friday, without the French public holidays); a negative number goes back

Parameters

    date:   The date - String - required
    n:   The number of business days - Number - required
admin
date add_business_days_fr "2026-12-18" 10
mentdb
2027-01-05

date add_business_days_fr <date> <n> <region>


Description

    Add business days with the holidays of a region

Parameters

    date:   The date - String - required
    n:   The number of business days - Number - required
    region:   alsace - String - required
admin
date add_business_days_fr "2026-12-23" 2 "alsace"
mentdb
2026-12-28
Used in use cases (1 recipe)

    Accountant & manager › Invoice total, VAT, amount in words and due date
Often used with

    math amount_in_words  ·  math vat  ·  table window

date business_days_fr <date1> <date2>


Description

    Number of business days between two dates (the first included, the last excluded), without the French public holidays

Parameters

    date1:   The first date - String - required
    date2:   The second date - String - required
admin
date business_days_fr "2026-05-01" "2026-06-01"
mentdb
17

date business_days_fr <date1> <date2> <region>


Description

    Number of business days with the holidays of a region

Parameters

    date1:   The first date - String - required
    date2:   The second date - String - required
    region:   alsace - String - required
admin
date business_days_fr "2026-12-01" "2027-01-01" "alsace"
mentdb
22

date iso_week <date>


Description

    ISO 8601 week of a date (the week of the Thursday), with its year: yyyy-Www

Parameters

    date:   The date - String - required
admin
date iso_week "2026-12-31"
mentdb
2026-W53
Belongs to the last week of 2026
admin
date iso_week "2027-01-02"
mentdb
2026-W53
Used in use cases (1 recipe)

    Integrator & ETL developer › Check a job schedule
Often used with

    date cron_next  ·  date duration_format  ·  date duration_parse  ·  date is_holiday_fr

date cron_next <cron> <from>


Description

    Next execution time of a cron expression (minute hour day_of_month month day_of_week; *, ranges, lists, steps, names jan... and sun...) after a timestamp

Parameters

    cron:   The cron expression - String - required
    from:   The timestamp yyyy-MM-dd HH:mm:ss - String - required
admin
date cron_next "30 8 * * mon-fri" "2026-11-06 09:00:00"
mentdb
2026-11-09 08:30:00

date cron_next <cron> <from> <count>


Description

    The next n execution times of a cron expression

Parameters

    cron:   The cron expression - String - required
    from:   The timestamp - String - required
    count:   The number of times - Number - required
admin
date cron_next "*/15 0-2 * * *" "2026-11-06 23:50:00" 4
mentdb
["2026-11-07 00:00:00", "2026-11-07 00:15:00", "2026-11-07 00:30:00", "2026-11-07 00:45:00"]
First day of each quarter at midnight
admin
date cron_next "0 0 1 1,4,7,10 *" "2026-11-06 12:00:00" 3
mentdb
["2027-01-01 00:00:00", "2027-04-01 00:00:00", "2027-07-01 00:00:00"]
Used in use cases (1 recipe)

    Integrator & ETL developer › Check a job schedule
Often used with

    date duration_format  ·  date duration_parse  ·  date is_holiday_fr  ·  date iso_week

date duration_parse <duration>


Description

    Duration in seconds from a text: 2h30, 1d 4h 15m, 90 min, 1 jour 3 heures, PT1H30M (ISO 8601), 01:30:00

Parameters

    duration:   The duration - String - required
admin
date duration_parse "2h30"
mentdb
9000
admin
date duration_parse "PT1H30M15S"
mentdb
5415
admin
date duration_parse "1 jour 3 heures"
mentdb
97200
Used in use cases (1 recipe)

    Integrator & ETL developer › Check a job schedule
Often used with

    date cron_next  ·  date duration_format  ·  date is_holiday_fr  ·  date iso_week

date duration_format <seconds> <format>


Description

    Format a duration in seconds: human (1d 2h 30m), iso (P1DT2H30M) or clock (26:30:00)

Parameters

    seconds:   The duration in seconds - Number - required
    format:   human, iso or clock - String - required
admin
date duration_format 95400 "human"
mentdb
1d 2h 30m
admin
date duration_format 95400 "iso"
mentdb
P1DT2H30M
admin
date duration_format 95400 "clock"
mentdb
26:30:00
Used in use cases (1 recipe)

    Integrator & ETL developer › Check a job schedule
Often used with

    date cron_next  ·  date duration_parse  ·  date is_holiday_fr  ·  date iso_week

date overlap <start1> <end1> <start2> <end2>


Description

    Overlap of two periods (dates or timestamps): true or false, the common period, its duration in seconds and days

Parameters

    start1:   Start of the first period - String - required
    end1:   End of the first period - String - required
    start2:   Start of the second period - String - required
    end2:   End of the second period - String - required
admin
date overlap "2026-07-01" "2026-07-15" "2026-07-10" "2026-07-20"
mentdb
{"overlap": true, "start": "2026-07-10 00:00:00", "end": "2026-07-15 00:00:00", "seconds": 432000, "days": 5}