User Tools
Dates_and_Times
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
|
Dates_and_Times [2017/06/09 19:32] JMichaelTX |
Dates_and_Times [2019/07/01 02:55] peternlewis |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| Dates and Times | Dates and Times | ||
| =============== | =============== | ||
| - | (Reference Page)\\ | + | |
| - | {{:date_and_time-icon.gif|}} **Keyboard Maestro offers a very full featured set of date and time [[Tokens|tokens]], formats, and calculations.**\\ | + | Keyboard Maestro offers a very full featured set of date and time [[Tokens|tokens]], formats, and calculations. |
| [[token:ICUDateTime|Date/Time tokens]] are like text expansion codes that return date/time values as text in the specified format. | [[token:ICUDateTime|Date/Time tokens]] are like text expansion codes that return date/time values as text in the specified format. | ||
| ===== Examples ===== | ===== Examples ===== | ||
| + | |||
| ==== 1. Get Current Date/Time ==== | ==== 1. Get Current Date/Time ==== | ||
| - | |||
| The most commonly used token is for returning the current date/time in the format you like: | The most commonly used token is for returning the current date/time in the format you like: | ||
| - | ''%ICUDateTime%**format**%'' where **format** is from the [ICU Date/Time codes](http://userguide.icu-project.org/formatparse/datetime#TOC-Date-Time-Format-Syntax).\\ | + | ''%ICUDateTime%**format**%'' where **format** is from the [ICU Date/Time codes](http://userguide.icu-project.org/formatparse/datetime#TOC-Date-Time-Format-Syntax). |
| For example, using the [[action:Set_Variable_to_Text|Set Variable to Text]] Action:\\ | For example, using the [[action:Set_Variable_to_Text|Set Variable to Text]] Action:\\ | ||
| Line 18: | Line 18: | ||
| ==== 2. Add Time to Date ==== | ==== 2. Add Time to Date ==== | ||
| + | |||
| This example adds days to the current date using a Keyboard Maestro Variable. See below for other options.{{:add-days-current-date-km-7.3.png?nolink|}} | This example adds days to the current date using a Keyboard Maestro Variable. See below for other options.{{:add-days-current-date-km-7.3.png?nolink|}} | ||
| For more info see this Forum Topic: [Add Time to Current Date @Example](https://forum.keyboardmaestro.com/t/date-add-time-to-current-date-example/7213), which provides instructions and a complete macro. | For more info see this Forum Topic: [Add Time to Current Date @Example](https://forum.keyboardmaestro.com/t/date-add-time-to-current-date-example/7213), which provides instructions and a complete macro. | ||
| - | |||
| - | --- | ||
| - | |||
| Line 70: | Line 68: | ||
| |**//%ICUDateTimeFor% TIME(<Year>, <Month>, <Day> [, <Hour>, <Min>, Sec>])%<format>%//**\\ Sets absolute date/time (GMT)|Set absolute date in **GMT**\\ %ICUDateTimeFor% TIME(2015, 12, 25) %EEE, MMM d, yyyy%\\ => Thu, Dec 24, 2015\\ \\ Set absolute date in **LOCAL** time\\ %ICUDateTimeFor% TIME(2015, 12, 25) **- GMTOFFSET()** %EEE, MMM d, yyyy%\\ => Fri, Dec 25, 2015| | |**//%ICUDateTimeFor% TIME(<Year>, <Month>, <Day> [, <Hour>, <Min>, Sec>])%<format>%//**\\ Sets absolute date/time (GMT)|Set absolute date in **GMT**\\ %ICUDateTimeFor% TIME(2015, 12, 25) %EEE, MMM d, yyyy%\\ => Thu, Dec 24, 2015\\ \\ Set absolute date in **LOCAL** time\\ %ICUDateTimeFor% TIME(2015, 12, 25) **- GMTOFFSET()** %EEE, MMM d, yyyy%\\ => Fri, Dec 25, 2015| | ||
| |**//%ICUDateTimePlus%<Formula for Quantity>%<TimeUnit>%<format>%//**\\ Using functions to calculate date offset.|**Get Date for Selected Prior Day Number**\\ `%ICUDateTimePlus%-(DOW() + 7 - DayNum)%Days%EEE, MMM d, yyyy%`\\ If Current Date is Dec 25, 2016, and _DayNum_ is 1:\\ => Sun, Dec 18, 2016\\ where "DayNum" is the number of the weekday (can be a Variable)| | |**//%ICUDateTimePlus%<Formula for Quantity>%<TimeUnit>%<format>%//**\\ Using functions to calculate date offset.|**Get Date for Selected Prior Day Number**\\ `%ICUDateTimePlus%-(DOW() + 7 - DayNum)%Days%EEE, MMM d, yyyy%`\\ If Current Date is Dec 25, 2016, and _DayNum_ is 1:\\ => Sun, Dec 18, 2016\\ where "DayNum" is the number of the weekday (can be a Variable)| | ||
| - | |||
| *where* | *where* | ||
| - | * *<TimeUnit> is one of the following: *Seconds, Minutes, Hours, Days, Weeks, Months, Years | + | * <TimeUnit> is one of the following: Seconds, Minutes, Hours, Days, Weeks, Months, Years, or a weekday, Sundays, Mondays, Tuesdays, Wednesdays, Thursdays, Fridays, Saturdays. |
| * <Quantity> is the number of <TimeUnit>s | * <Quantity> is the number of <TimeUnit>s | ||
| * <format> is the format of text returned, using the [ICU Date/Time codes](http://userguide.icu-project.org/formatparse/datetime#TOC-Date-Time-Format-Syntax) | * <format> is the format of text returned, using the [ICU Date/Time codes](http://userguide.icu-project.org/formatparse/datetime#TOC-Date-Time-Format-Syntax) | ||
| Line 85: | Line 82: | ||
| Since [[function:TIME|TIME()]] and [[function:NOW|NOW()]] returns the specified date/time in GMT :!: , you can adjust for your local time zone by subtracting the [[function:GMTOFFSET|GMTOFFSET()]] function | Since [[function:TIME|TIME()]] and [[function:NOW|NOW()]] returns the specified date/time in GMT :!: , you can adjust for your local time zone by subtracting the [[function:GMTOFFSET|GMTOFFSET()]] function | ||
| - | :!: FIXME -- this has been [[https://forum.keyboardmaestro.com/t/issue-with-date-time-functions/5856 | disputed]]. `NOW()` and `TIME()` may be based on local time. | + | [[token:ICUDateTimeFor|%ICUDateTimeFor%]] [[function:TIME|TIME(2015, 12, 25)]] - [[function:GMTOFFSET|GMTOFFSET()]] %EEE, MMM d, yyyy% => Fri, Dec 25, 2015 |
| - | + | ||
| - | [[token:ICUDateTimeFor|%ICUDateTimeFor%]] [[function:TIME|TIME(2015, 12, 25)]] - [[function:GMTOFFSET|GMTOFFSET()]] %EEE, MMM d, yyyy%\\ | + | |
| - | => Fri, Dec 25, 2015 | + | |
| ===== Date/Time Functions and Calculations ===== | ===== Date/Time Functions and Calculations ===== | ||
| Line 117: | Line 111: | ||
| * [[unixtime]] in GMT | * [[unixtime]] in GMT | ||
| - | ==== Mixing Functions and Tokens ==== | + | ===== Mixing Functions and Tokens ===== |
| - | + | ||
| - | You might expect [[token:ICUDateTimeFor|%ICUDateTimeFor%]] [[function:TIME|TIME(2017, 1, 1)]] `%EEE, MMM d, yyyy%` to yield `Sun, Jan 1, 2017`.\\ | + | |
| - | However, it may yield `Sat, Dec 31, 2016`, depending on your local time zone. | + | |
| + | You might expect [[token:ICUDateTimeFor|%ICUDateTimeFor%]] [[function:TIME|TIME(2017, 1, 1)]] `%EEE, MMM d, yyyy%` to yield `Sun, Jan 1, 2017`. However, it may yield `Sat, Dec 31, 2016`, depending on your local time zone. | ||
| Here is why: | Here is why: | ||
| Line 135: | Line 127: | ||
| For a more complete discussion on the many different ways to use date and times, see [KM dates & times: Notes on anchors, intervals, and translations](https://forum.keyboardmaestro.com/t/km-dates-times-notes-on-anchors-intervals-and-translations/1935) (Aug 2015), with contributions by @[ComplexPoint](https://forum.keyboardmaestro.com/users/ComplexPoint), @[peternlewis](https://forum.keyboardmaestro.com/users/peternlewis), and others. | For a more complete discussion on the many different ways to use date and times, see [KM dates & times: Notes on anchors, intervals, and translations](https://forum.keyboardmaestro.com/t/km-dates-times-notes-on-anchors-intervals-and-translations/1935) (Aug 2015), with contributions by @[ComplexPoint](https://forum.keyboardmaestro.com/users/ComplexPoint), @[peternlewis](https://forum.keyboardmaestro.com/users/peternlewis), and others. | ||
| + | |||
| + | ===== Localization ===== | ||
| + | |||
| + | Prior to Mojave, and after Keyboard Maestro 9.0, dates should be in your chosen language. Unfortunately Apple changed Mojave and later to make the system return dates only in the Keyboard Maestro localized language (ie, English), regardless of your chosen locale. Keyboard Maestro 9.0 works around this by claiming to be in all locales, even though it is really only localized for English itself. | ||
| ===== See Also ===== | ===== See Also ===== | ||
| - | ---- | + | ==== Actions ==== |
| - | === Actions === | + | * [[action:Filter|Filter]] (Process Text Tokens) |
| - | + | ||
| - | * [[action:Filter Clipboard|Filter Clipboard]] (Process Text Tokens) | + | |
| - | * [[action:Filter Variable|Filter Variable]] (Process Text Tokens) | + | |
| * [[:Actions|See all Actions]] | * [[:Actions|See all Actions]] | ||
| - | |||
| - | ---- | ||
| ==== Forum ==== | ==== Forum ==== | ||
| Line 154: | Line 145: | ||
| - [[https://forum.keyboardmaestro.com/t/previous-date-variables-best-way/3311/4|Previous Date Variables]] | - [[https://forum.keyboardmaestro.com/t/previous-date-variables-best-way/3311/4|Previous Date Variables]] | ||
| - [[https://forum.keyboardmaestro.com/t/icudatetime-format-from-locale/3458/5|%ICUDateTime% format from locale]] | - [[https://forum.keyboardmaestro.com/t/icudatetime-format-from-locale/3458/5|%ICUDateTime% format from locale]] | ||
| + | - [[https://forum.keyboardmaestro.com/t/issue-with-date-time-functions/5856|Issue with Date/Time Functions]] | ||
| - [[https://forum.keyboardmaestro.com/tags/date_time|Keyboard Maestro Forum topics about Dates and Times]] | - [[https://forum.keyboardmaestro.com/tags/date_time|Keyboard Maestro Forum topics about Dates and Times]] | ||
| - | ==== Related Pages ==== | ||
| - | |||
| - | TBD\\ | ||
| - | |||
| - | |||
| - | ---- | ||
| - | If you find any issues, or have any suggestions, concerning this page, please report them to [Draft Rewrite of Wiki Dates and Times Article](https://forum.keyboardmaestro.com/t/draft-rewrite-of-wiki-dates-and-times-article/2485/1) | ||
Dates_and_Times.txt · Last modified: 2023/06/20 02:44 by peternlewis
Page Tools
