if(less(variables('ThisMonth'),4),'3Q',if(less(variables('ThisMonth'),7),'1Q',if(less(variables('ThisMonth'),10),'2Q','3Q')))現在時刻取得
convertTimeZone(utcNow(),'GMT Standard Time','Tokyo Standard Time','u')
月Monthを取得 variables('ThisMonth')
variables('ThisMonth'):
int(formatDateTime(convertTimeZone(utcNow(),'GMT Standard Time','Tokyo Standard Time','u'),'MM'))
日付フォーマット
タイムゾーン名、タイムゾーンID
- GMT Standard Time
- Tokyo Standard Time
Summary
The table below lists out the Microsoft Time Zone Index Values.
More Information
| Index (hex) | Name of Time Zone | Time |
|---|---|---|
| 0 | Dateline Standard Time | (GMT-12:00) International Date Line West |
| 1 | Samoa Standard Time | (GMT-11:00) Midway Island, Samoa |
| 2 | Hawaiian Standard Time | (GMT-10:00) Hawaii |
| 3 | Alaskan Standard Time | (GMT-09:00) Alaska |
| 4 | Pacific Standard Time | (GMT-08:00) Pacific Time (US and Canada); Tijuana |
| A | Mountain Standard Time | (GMT-07:00) Mountain Time (US and Canada) |
| D | Mexico Standard Time 2 | (GMT-07:00) Chihuahua, La Paz, Mazatlan |
| F | U.S. Mountain Standard Time | (GMT-07:00) Arizona |
| 14 | Central Standard Time | (GMT-06:00) Central Time (US and Canada) |
| 19 | Canada Central Standard Time | (GMT-06:00) Saskatchewan |
| 1E | Mexico Standard Time | (GMT-06:00) Guadalajara, Mexico City, Monterrey |
| 21 | Central America Standard Time | (GMT-06:00) Central America |
| 23 | Eastern Standard Time | (GMT-05:00) Eastern Time (US and Canada) |
| 28 | U.S. Eastern Standard Time | (GMT-05:00) Indiana (East) |
| 2D | S.A. Pacific Standard Time | (GMT-05:00) Bogota, Lima, Quito |
| 32 | Atlantic Standard Time | (GMT-04:00) Atlantic Time (Canada) |
| 37 | S.A. Western Standard Time | (GMT-04:00) Georgetown, La Paz, San Juan |
| 38 | Pacific S.A. Standard Time | (GMT-04:00) Santiago |
| 3C | Newfoundland and Labrador Standard Time | (GMT-03:30) Newfoundland |
| 41 | E. South America Standard Time | (GMT-03:00) Brasilia |
| 46 | S.A. Eastern Standard Time | (GMT-03:00) Georgetown |
| 49 | Greenland Standard Time | (GMT-03:00) Greenland |
| 4B | Mid-Atlantic Standard Time | (GMT-02:00) Mid-Atlantic |
| 50 | Azores Standard Time | (GMT-01:00) Azores |
| 53 | Cape Verde Standard Time | (GMT-01:00) Cape Verde Islands |
| 55 | GMT Standard Time | (GMT) Greenwich Mean Time: Dublin, Edinburgh, Lisbon, London |
| 5A | Greenwich Standard Time | (GMT) Monrovia, Reykjavik |
| 5F | Central Europe Standard Time | (GMT+01:00) Belgrade, Bratislava, Budapest, Ljubljana, Prague |
| 64 | Central European Standard Time | (GMT+01:00) Sarajevo, Skopje, Warsaw, Zagreb |
| 69 | Romance Standard Time | (GMT+01:00) Brussels, Copenhagen, Madrid, Paris |
| 6E | W. Europe Standard Time | (GMT+01:00) Amsterdam, Berlin, Bern, Rome, Stockholm, Vienna |
| 71 | W. Central Africa Standard Time | (GMT+01:00) West Central Africa |
| 73 | E. Europe Standard Time | (GMT+02:00) Minsk |
| 78 | Egypt Standard Time | (GMT+02:00) Cairo |
| 7D | FLE Standard Time | (GMT+02:00) Helsinki, Kiev, Riga, Sofia, Tallinn, Vilnius |
| 82 | GTB Standard Time | (GMT+02:00) Athens, Bucharest, Istanbul |
| 87 | Israel Standard Time | (GMT+02:00) Jerusalem |
| 8C | South Africa Standard Time | (GMT+02:00) Harare, Pretoria |
| 91 | Russian Standard Time | (GMT+03:00) Moscow, St. Petersburg, Volgograd |
| 96 | Arab Standard Time | (GMT+03:00) Kuwait, Riyadh |
| 9B | E. Africa Standard Time | (GMT+03:00) Nairobi |
| 9E | Arabic Standard Time | (GMT+03:00) Baghdad |
| A0 | Iran Standard Time | (GMT+03:30) Tehran |
| A5 | Arabian Standard Time | (GMT+04:00) Abu Dhabi, Muscat |
| AA | Caucasus Standard Time | (GMT+04:00) Baku, Tbilisi, Yerevan |
| AF | Transitional Islamic State of Afghanistan Standard Time | (GMT+04:30) Kabul |
| B4 | Ekaterinburg Standard Time | (GMT+05:00) Ekaterinburg |
| B9 | West Asia Standard Time | (GMT+05:00) Tashkent |
| BE | India Standard Time | (GMT+05:30) Chennai, Kolkata, Mumbai, New Delhi |
| C1 | Nepal Standard Time | (GMT+05:45) Kathmandu |
| C3 | Central Asia Standard Time | (GMT+06:00) Astana, Dhaka |
| C8 | Sri Lanka Standard Time | (GMT+06:00) Sri Jayawardenepura |
| C9 | N. Central Asia Standard Time | (GMT+06:00) Almaty, Novosibirsk |
| CB | Myanmar Standard Time | (GMT+06:30) Yangon (Rangoon) |
| CD | S.E. Asia Standard Time | (GMT+07:00) Bangkok, Hanoi, Jakarta |
| CF | North Asia Standard Time | (GMT+07:00) Krasnoyarsk |
| D2 | China Standard Time | (GMT+08:00) Beijing, Chongqing, Hong Kong, Urumqi |
| D7 | Singapore Standard Time | (GMT+08:00) Kuala Lumpur, Singapore |
| DC | Taipei Standard Time | (GMT+08:00) Taipei |
| E1 | W. Australia Standard Time | (GMT+08:00) Perth |
| E3 | North Asia East Standard Time | (GMT+08:00) Irkutsk, Ulaanbaatar |
| E6 | Korea Standard Time | (GMT+09:00) Seoul |
| EB | Tokyo Standard Time | (GMT+09:00) Osaka, Sapporo, Tokyo |
| F0 | Yakutsk Standard Time | (GMT+09:00) Yakutsk |
| F5 | A.U.S. Central Standard Time | (GMT+09:30) Darwin |
| FA | Cen. Australia Standard Time | (GMT+09:30) Adelaide |
| FF | A.U.S. Eastern Standard Time | (GMT+10:00) Canberra, Melbourne, Sydney |
| 104 | E. Australia Standard Time | (GMT+10:00) Brisbane |
| 109 | Tasmania Standard Time | (GMT+10:00) Hobart |
| 10E | Vladivostok Standard Time | (GMT+10:00) Vladivostok |
| 113 | West Pacific Standard Time | (GMT+10:00) Guam, Port Moresby |
| 118 | Central Pacific Standard Time | (GMT+11:00) Magadan, Solomon Islands, New Caledonia |
| 11D | Fiji Islands Standard Time | (GMT+12:00) Fiji, Kamchatka, Marshall Is. |
| 122 | New Zealand Standard Time | (GMT+12:00) Auckland, Wellington |
| 12C | Tonga Standard Time | (GMT+13:00) Nuku'alofa |
| 80000040 | Azerbaijan Standard Time | (GMT-03:00) Buenos Aires |
| 80000041 | Middle East Standard Time | (GMT+02:00) Beirut |
| 80000042 | Jordan Standard Time | (GMT+02:00) Amman |
| 80000043 | Central Standard Time (Mexico) | (GMT-06:00) Guadalajara, Mexico City, Monterrey - New |
| 80000044 | Mountain Standard Time (Mexico) | (GMT-07:00) Chihuahua, La Paz, Mazatlan - New |
| 80000045 | Pacific Standard Time (Mexico) | (GMT-08:00) Tijuana, Baja California |
| 80000046 | Namibia Standard Time | (GMT+02:00) Windhoek |
| 80000047 | Georgian Standard Time | (GMT+03:00) Tbilisi |
| 80000048 | Central Brazilian Standard Time | (GMT-04:00) Manaus |
| 80000049 | Montevideo Standard Time | (GMT-03:00) Montevideo |
| 8000004A | Armenian Standard Time | (GMT+04:00) Yerevan |
| 8000004B | Venezuela Standard Time | (GMT-04:30) Caracas |
| 8000004C | Argentina Standard Time | (GMT-03:00) Buenos Aires |
| 8000004D | Morocco Standard Time | (GMT) Casablanca |
| 8000004E | Pakistan Standard Time | (GMT+05:00) Islamabad, Karachi |
| 8000004F | Mauritius Standard Time | (GMT+04:00) Port Louis |
| 80000050 | UTC | (GMT) Coordinated Universal Time |
| 80000051 | Paraguay Standard Time | (GMT-04:00) Asuncion |
| 80000052 | Kamchatka Standard Time | (GMT+12:00) Petropavlovsk-Kamchatsky |