Differences

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

--- transformations:convert [2021/04/02 23:27] – craigt
+++ transformations:convert [2023/10/05 17:01] (current) – [Text to Date settings] dmitry
@@ Line 38: / Line 38: @@
 ====Text to Date settings====
 ^Setting^Description^
-|Format<sup>*</sup>|Enter the date format the current text dates are using (e.g. yyyy-MM-dd).  Use the //Detect// button to populate this field with any date formats found within the column.|
+|Format<sup>*</sup>|Enter the date format the current text dates are using (e.g. yyyy-MM-dd).  Use the //Detect// button to populate this field with the date format found within the column. If the auto-detection didn't work, compose the format string manually using the table below.|
 <sup>*</sup> Setting can be specified using a [[:parameters|parameter]].\\
+\\
+==== Date-Time format string components ====
+A //format string// defines a formatting template for dates and times. Its components can be put together in any combination. If a character doesn't belong to a format component then it's inserted verbatim.
+:!: The specifiers below are case-sensitive.
+^  Date format specifier^  Description  ^
+|  d  |The day of the month, from 1 through 31.  |
+|  dd  |The day of the month, from 01 through 31.  |
+|  ddd  |The abbreviated name of the day of the week.  |
+|  M  |The month, from 1 through 12.  |
+|  MM  |The month, from 01 through 12.  |
+|  MMM  |The abbreviated name of the month.  |
+|  MMMM  |The full name of the month.  |
+|  y  |The year, from 0 to 99.  |
+|  yy  |The year, from 00 to 99.  |
+|  yyyy  |The year as a four-digit number.  |
+^  Time format specifier^  Description  ^
+|  h  |The hour, using a 12-hour clock from 1 to 12.  |
+|  hh  |The hour, using a 12-hour clock from 01 to 12.  |
+|  H  |The hour, using a 24-hour clock from 0 to 23.  |
+|  HH  |The hour, using a 24-hour clock from 00 to 23.  |
+|  m  |The minute, from 0 through 59.  |
+|  mm  |The minute, from 00 through 59.  |
+|  s  |The second, from 0 through 59.  |
+|  ss  |The second, from 00 through 59.  |
+|  t  |The first character of the AM/PM designator.  |
+|  tt  |The AM/PM designator.  |
 \\
 ====Text to Number settings====
 ^Setting^Description^
 |Decimal separator|Select what character is used to define decimal places in the source text values.  Options:  //Point// or //Comma//.|
+|Thousand separator|Select what character is used to define thousands places in the source text values.  Options:  //Default//, //Comma//,\\ //Point// or //Space//.|
 \\
 ====Everything to Text settings====
@@ Line 84: / Line 116: @@
 |  1'000.00  |  5500 |5,500.00 |
 |  yyyy/MM/dd  |  22335 |1961/02/23 |
+\\
+====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: //3//)
+  * [[https://community.easymorph.com/t//2166/2|Date condition for specific dates]] ([[https://community.easymorph.com/uploads/short-url/hEAQZ5dAEMQk2xUZVJucAo2kJTz.morph|Project]]; Module: //Main//; Group: //Group 1//; Table: //TR101.xlsx//; Action position: //2//)
+  * [[https://community.easymorph.com/t//2292/2|Assign value from conditions based on a table]] ([[https://community.easymorph.com/uploads/short-url/hsFachkdfbcKFoA2ZK8WcmOUfA9.morph|Project]]; Module: //Main//; Group: //Group 1//; Table: //Table 1//; Action position: //4//)
+  * [[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: //3//)
 \\