Recent

Nintex Forms FormatDate Formats

Using the FormatDate() date function, you can choose to make a date or time display however you would like on your form:
NF-Calculated-Value-Examples-16-8

The table below shows the different date and time formatting options that can be used with the FormatDate() function.  For more examples of formatted or calculated dates, please see the Calculated Values Example Tutorial.

Format Value: Example Returned Value
d Short Date: 4/17/2016 3:30PM 4/17/2016
D Long Date: 4/17/2016 3:30PM Sunday, April 17, 2016
s Sortable Date/Time: 4/17/2016 3:30PM 2016-04-16T15:30:00
MM Month: 4/17/2016 3:30PM 04
MMM Month: 4/17/2016 3:30PM  Apr
MMMM Month: 4/17/2016 3:30PM  April
dd Day: 4/17/2016 3:30PM 17
ddd Day: 4/17/2016 3:30PM S
dddd Day: 4/17/2016 3:30PM Sunday
yyyy Year: 4/17/2016 3:30PM 2016
yy Year: 4/17/2016 3:30PM 15
hh 12 hr: 4/17/2016 3:30PM 3
HH 24 hr: 4/17/2016 3:30PM 15
mm Minutes: 4/17/2016 3:30PM 30
tt AM/PM:  4/17/2016 3:30PM PM
t short time: 4/17/2016 3:30PM 3:30PM
T Long time: 4/17/2016 3:30PM  3:30:00PM
About Nick Hurst (84 Articles)
SharePoint and Nintex developer who strives to find easy to deploy and maintain solutions for business problems.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: