Free cookie consent management tool by TermsFeed datetext() Function
datetext() Function
This function cannot be used with Offline Mobile or Custom Record Field Expressions.
For a full list of functions and their feature compatibility, explore the Appian Functions table.


datetext( value, format )

Interprets the date or datetime specified in the user's preferred calendar and returns its string representation using given format.


Keyword Type Description


Date or Date and Time

The value to convert to a text string.



The pattern you want to use for the output.




You can copy and paste these examples into the Expression Rule Designer to see how this works.

datetext(userdatevalue("8/18/1427"),"yyyy/MM/dd") returns 1427/8/18

The datetext() function uses a similar, but slightly different syntax than the text function.

Letter Date or Time Component Presentation Examples
G Era designator Text AD
y Year Year 1996; 96
Y Week Year Year 2009; 09
M Month in year Month July; Jul; 07
w Week in year Number 27
W Week in month Number 2
D Day in year Number 189
d Day in month Number 10
F Day of week in month Number 2
E Day name in week Text Tuesday; Tue
a Am/pm marker Text PM
H Hour in day (0-23) Number 0
k Hour in day (1-24) Number 24
K Hour in am/pm (0-11) Number 0
h Hour in am/pm (1-12) Number 12
m Minute in hour Number 30
s Second in minute Number 55
S Millisecond Number 97
z Time zone General time zone Pacific Standard Time; PST; GMT-08:00
Z Time zone RFC 822 time zone -0800
Open in Github Built: Fri, Nov 10, 2023 (03:42:48 PM)

datetext() Function