Differences

This shows you the differences between two versions of the page.

--- transformations:makedatetimecolumns [2021/04/23 18:17] – craigt
+++ transformations:makedatetimecolumns [2021/07/19 02:24] (current) – [Examples] craigt
@@ Line 64: / Line 64: @@
   * __The Column Profile/Filter window:__  In the //Values// tab, you will see date/time values leading with the date serial number (e.g., 32888  15-Jan-1990), while text-based values will only show the value (e.g., 15-Jan-1990).  In the //Metadata// tab, the number format for date/times will be "dd-MMM-yyyy" while text values will not have a number format.
   * __Analysis View, Table metadata:__ Date/time column values will show counts under "numbers" and "integers" while text-based values will show counts under "text".  (These same results will appear using the //Table metadata// action.)
 \\
 =====Examples=====
-**Objective:** Create columns with year-quarter, week day, and ISO week number.\\
+**Example:** Create columns with year-quarter, week day, and ISO week number.\\
 **Source table:**
@@ Line 82: / Line 79: @@
 > Select options "Year-quarter", "Week day" (output "English"), and "ISO week number".
 \\
-**Result:**
+**Result table:**
 ^ Date ^ Year-quarter ^ Week day ^ ISO Week number ^
 | 2020-Nov-28  | 2020-Q4  | Sat  |  48|
 | 2020-Nov-29  | 2020-Q4  | Sun  |  48|
 | 2020-Nov-30  | 2020-Q4  | Mon  |  49|
+\\
+====Community examples====
+  * [[https://community.easymorph.com/t//1587/7|How to format the duration in more than 24h]] ([[https://community.easymorph.com/uploads/short-url/w6CnxwiidYjcJHNRrmUIXI74NC2.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Table 1//; Action position: //5//)
+  * [[https://community.easymorph.com/t//2297/2|Excel: Import Date Headings as number]] ([[https://community.easymorph.com/uploads/short-url/ppgiXxeiQbK0O3owwca3pxAsOyH.morph|Project]]; Module: //Main//; Group: //Group 1//; Table: //New header//; Action position: //4//)
 \\