transformations:calendar
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
transformations:calendar [2015/10/01 21:45] – created dmitry | transformations:calendar [2021/04/02 04:33] (current) – [Examples] dmitry | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Calendar | + | {{ transformations: |
+ | ====== | ||
+ | Category: Create / Generate\\ | ||
- | This transformation | + | \\ |
+ | =====Description===== | ||
+ | This action | ||
+ | |||
+ | \\ | ||
+ | =====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. | ||
+ | |||
+ | \\ | ||
+ | =====Action settings===== | ||
+ | ====From==== | ||
+ | ^ Setting | ||
+ | |Date< | ||
+ | |Today|Set the starting date as today' | ||
+ | |# days back< | ||
+ | < | ||
+ | \\ | ||
+ | ====To==== | ||
+ | ^ Setting | ||
+ | |Date< | ||
+ | |Today|Set the ending date as today' | ||
+ | |# days ahead< | ||
+ | < | ||
+ | \\ | ||
+ | ====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/ | ||
+ | |||
+ | \\ | ||
+ | =====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| | ||
+ | |||
+ | \\ | ||
+ | =====See also===== | ||
+ | * [[transformations: |
transformations/calendar.1443750357.txt.gz · Last modified: 2015/10/01 21:45 by dmitry