Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version next

...

Integer literal values:

DATEFORMAT(DATE
d-codelang-syntax
RawWrangletrue
Typeref
showNotetrue
WrangleTextderive type:single value:
dateformat(date(2015,02,15),'yyyy-MM-dd')

dateformat(date(2015,02,15),'yyyy-MM-dd')

Output:

...

Returns the formatted date value: 2015-02-15.

Column reference values:

DATEFORMAT( DATE
d-codelang-syntax
RawWrangletrue
Typeref
showNotetrue
WrangleTextderive type:single value:
dateformat(date(myYear, myMonth, myDay),'MMM yyyy')

dateformat(date(myYear, myMonth, myDay),'MMM yyyy')

Output: Generates a column of date values where:

  • MMM = short value for myMonth
  • yyyy = value from myYear

Returns date values based on three columns, formatted for date.


D s
snippetSyntax

DATEFORMAT(DATE
d-codelang-syntax
RawWrangletrue
Typesyntax
showNotetrue
WrangleTextderive type:single value:
dateformat(date(year_integer_col,month_integer_col,day_Integer_col ),'date_format_string')

dateformat(date(year_integer_col,month_integer_col,day_Integer_col ),'date_format_string')


ArgumentRequired?Data TypeDescription
year_integer_colYintegerName of column or Integer literal representing the year value to apply to the function
month_integer_colYintegerName of column or Integer literal representing the month value to apply to the function
day_integer_colYintegerName of column or Integer literal representing the day value to apply to the function
date_format_stringYstringString literal identifying the date format to apply to the value

...