Format Date

Syntax

Function:
  • FORMAT-DATE(value, format)
Parameters:
  • value =  a numeric value
  • format =  a combination of text or character forming the format specifiers
Description:
  • The FORMAT-DATE() function converts a date/time to a formatted string value.
Typical format specifiers include:
  • yy  – 2 digit year
  • yyyy  – 4 digit year
  • MM  – 2 digit month
  • MMM  – 3 character abbreviated month
  • dd  – 2 digit day
  • HH  – hour in 24 hour clock
  • mm  – 2 digit minute (00-59)
  • ss  – 2 digit second (00-59)
  • Learn more about format specifiers from Microsoft
Used:
in a Formula BuilderFormula Builder

 

Example
Result
Note
FORMAT-DATE(today(), 'dd-MM-yy H:mm:ss') 27-03-15 16:23:32
FORMAT-DATE(today(), 'ddd/MMM/yyyy') Fri/Mar/2015
FORMAT-DATE(today(), 'dddd dd MMMM yyyy') Friday 27 March 2015

 

 

date(). Process Steps. int(). boolean(). utcnow(). round(). cosh(). userfirstname(). counter(). pi(). string(). acos(). random(). Text based Functions. ‘.’ (dot). param1(). tanh(). tan(). Choices Functions. Excel Financial Functions.