transformations:calendar
no way to compare when less than two revisions
Differences
This shows you the differences between two versions of the page.
Previous revisionNext revision | |||
— | transformations:calendar [2021/03/14 01:01] – craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | {{ transformations: | ||
+ | ====== CALENDAR ====== | ||
+ | Category: Create / Generate | ||
+ | |||
+ | =====Description===== | ||
+ | This action creates a table with a list of dates for a specified date range. One row corresponds to one day. Start and end dates can be defined as an absolute or relative date, or defined by a parameter.\\ | ||
+ | |||
+ | \\ | ||
+ | =====Action settings===== | ||
+ | ====From==== | ||
+ | ^ Setting | ||
+ | |Date|Select an absolute starting date value using the date-picker.| | ||
+ | |Today|Set the starting date as today' | ||
+ | |# days back|If the //To// setting is either an absolute date or Today, this sets the starting time as the number of days prior to the //To// date.\\ | ||
+ | |||
+ | ====To==== | ||
+ | ^ Setting | ||
+ | |Date|Select an absolute ending date value using the date-picker.| | ||
+ | |Today|Set the ending date as today' | ||
+ | |# days ahead|If the //From// setting is either an absolute date or Today, this sets the ending time as the number of days after the //From// date.\\ | ||
+ | |||
+ | ====Columns==== | ||
+ | These options define the columns that will be included in the generated dataset. | ||
+ | ^ Setting | ||
+ | |Date as number|When selected, dates are generated as number values with a format of dd-MMM-yyyy (e.g. 10-Mar-2021).| | ||
+ | |Formatted date|Generates text-based date values using the selected format.\\ | ||
+ | |Year|Geneates a list of year values in yyyy format (e.g. 2021).| | ||
+ | |Month number|Generates a list of numeric month numbers (1-12).| | ||
+ | |Month name|Generates a list of abbreviated month names (e.g. Jan, Feb, Mar).| | ||
+ | |Day|Generates a list of day numbers.| | ||
+ | |Day of week (number)|Generates a list of weekday numbers from 1 (Sunday) to 7 (Saturday).| | ||
+ | |Day of week (name)|Generates a list of weekday full names (e.g. " | ||
+ | |Weekend flag|Generates a list of Boolean values (TRUE/ | ||
+ | |||
+ | \\ | ||
+ | =====Use cases===== | ||
+ | Use this action when you need to create a dataset of date-based values (days, weeks, weekdays, months, or years) to be used downstream. | ||
+ | |||
+ | \\ | ||
+ | =====Examples===== | ||
+ | For the date "March 20, 2021" the following settings will produce the following output values: | ||
+ | ^Setting^Output^ | ||
+ | |Date as number|20-Mar-2021| | ||
+ | |Formatted date|// | ||
+ | |Year|2021| | ||
+ | |Month number|3| | ||
+ | |Month name|Mar| | ||
+ | |Day|20| | ||
+ | |Day of week (number)|7| | ||
+ | |Day of week (name)|Saturday| | ||
+ | |Weekend flag|TRUE| | ||
+ | |||
+ | |||
transformations/calendar.txt · Last modified: 2021/04/02 04:33 by dmitry