Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Button handy
blanktrue
color#0052CC
nameSend Feedback
linkhttps://docs.google.com/forms/d/e/1FAIpQLScmToBe3vynAlb5fdKwCGxYqnTbDc66sIBgeecG2BuFDuHc7g/viewform?entry.2002826954=formatDate+-+434733388
widthauto

Table plus
applyColStyleToCelltrue
heading0
columnTypess,s,s,s
multiplefalse
columnAttributesstyle="background:#e5e7ea;font-weight:bold,,style="background:#e5e7ea;font-weight:bold,
enableSortingfalse

Syntax

formatDate(date, format)

Package

Alias

Pkg Usage

...

Examples

Example 1

Code Block
languagejs
string format = "yyyy.MM.dd G 'at' HH:mm:ss z";
print("Current time is " + formatDate(currentDate(), format));

Assuming that current date is 30.10.2011 and time 12:08, prints Today is 2011.10.30 AD at 12:08:00 PDT

Example 2

Code Block
languagejs
date varDateTime = "2011 -08 -17 T18: 30: 55";
string format = "EEE, d MMM yyyy HH:mm:ss Z";
print ("Formatted date is" + formatDate(varDateTime,format));

...

Filter by label (Content by label)
showLabelsfalse
max25
showSpacefalse
cqllabel = "date_routine" and space = currentSpace ( )
labelsarray_routines

We've encountered an issue exporting this macro. Please try exporting this page again later.