FORMATTING DATES AND TIMES

Below is the complete, authoritative list of every date/time token Articles understands, plus ready‑to‑use examples you can paste directly into expressions.

Core Date Token

Year

• y — 1‑digit year (e.g., 5)
• yy — 2‑digit year (e.g., 25)
• yyy — 3‑digit year (rarely used)
• yyyy — 4‑digit year (e.g., 2025)

Month

• m — month number without leading zero (2)
• mm — month number with leading zero (02)
• mmm — short month name (Feb)
• mmmm — full month name (February)

Day

• d — day without leading zero (7)
• dd — day with leading zero (07)
• ddd — short weekday name (Tue)
• dddd — full weekday name (Tuesday)

Time Tokens

Hour

• h — hour (0–23)
• hh — hour with leading zero

Minute

• n — minute
• nn — minute with leading zero

Second

• s — second
• ss — second with leading zero

AM/PM

• am/pm — lowercase
• AM/PM — uppercase
• a/p — a or p
• A/P — A or P

USA formats

• mm/dd/yyyy → 02/26/2026
• mmmm d, yyyy → February 26, 2026
• mmm d, yyyy → Feb 26, 2026

International formats

• dd/mm/yyyy → 26/02/2026
• yyyy-mm-dd → 2026-02-26
• d mmm yyyy → 26 Feb 2026

With weekday

• dddd, mmmm d, yyyy → Thursday, February 26, 2026
• ddd, mmm d → Thu, Feb 26

With time

• hh:nn:ss → 14:05:33
• h:nn AM/PM → 2:05 PM
• mmmm d, yyyy hh:nn → February 26, 2026 14:05

Articles Expression Examples

Simple

FormatDateTime('mm/dd/yyyy',<Customers."CustomerSince">)

Full sentence

'Customer since ' + FormatDateTime('mmmm d, yyyy', <Customers."CustomerSince">)

With weekday

FormatDateTime('dddd, mmmm d, yyyy', <Customers."CustomerSince">)

Articles Notes (Important)

Always use single quotes around the format string.

Always wrap dataset fields in parentheses if used inside functions.

If using inside a memo expression you need to add [ ] around the function because Article needs to treat as a function not text. Example:

Dear [Customers."Customer_Bill_Name"],

Thank you for being a customer since [formatdatetime('mmmm d, yyyy',<Customers."CustomerSince">)].

Your current balance is:  [FormatFloat('#,##0.00',<Customers."Balance">)].