Using the date.today() Feature

In some cases, you may want a document to generate a date based on the current day. This is based on the UTC date—you may see a difference in an hour during daylight saving time. If the hour is important to you, then additional conditional logic is required.

There are two options to create a current date. First, add it as a formula. Second, add the expression straight into the template. This guide will walk you through both ways. You can watch the accompanying video here

Current Date as a Formula

Navigate to the formulas tab in the online workspace. Select Add a new formula and create a current date formula. Verify that it is a single-date formula. 

Enter the expression. Note that in our example we are creating the Eastern time zone. If you are in a different time zone, view the table below to determine what number you will insert in the parentheses (). Select Save.

date.today(-5)

Open the template you are working on. Select the formula and update any formatting option you would like. 

The benefit of creating the current date as a formula is that you only need to create it once and can reuse it in any template. You also have one location in which you have to update information—for example, if you should change time zones, edit the formula in the online workspace by updating the number in parentheses.

Current Date as an Expression

Open the template you wish to add the current date to. Note in our example we are creating the Pacific time zone. If you are in a different time zone, view the table below to determine what number you will insert in the parentheses (). 

Enter the expression. Be sure to surround the expression with the proper use of brackets. You can also add formatting at this step.

{[date.today(-8)|format: “MM, DD, YYYY”]}

Select Save.

UTC Numbers

American Samoa -0.46
International Date Line West -0.46
Midway Island -0.46
Hawaii -0.42
Alaska -0.38
Pacific Time (US & Canada) -0.33
Tijuana -0.33
Arizona -0.29
Chihuahua -0.29
Mazatlan -0.29
Mountain Time (US & Canada) -0.29
Central America -0.25
Central Time (US & Canada) -0.25
Guadalajara -0.25
Mexico City -0.25
Monterrey -0.25
Saskatchewan -0.25
Bogota -0.21
Eastern Time (US & Canada) -0.21
Indiana (East) -0.21
Lima -0.21
Quito -0.21
Caracas -0.19
Atlantic Time (Canada) -0.17
Georgetown -0.17
La Paz -0.17
Santiago -0.17
Newfoundland -0.15
Brasilia -0.13
Buenos Aires -0.13
Greenland -0.13
Mid-Atlantic -0.08
Azores -0.04
Cape Verde Is. -0.04
Casablanca +00:00
Dublin +00:00
Edinburgh +00:00
Lisbon +00:00
London +00:00
Monrovia +00:00
UTC +00:00
Amsterdam +01:00
Belgrade +01:00
Berlin +01:00
Bern +01:00
Bratislava +01:00
Brussels +01:00
Budapest +01:00
Copenhagen +01:00
Ljubljana +01:00
Madrid +01:00
Paris +01:00
Prague +01:00
Rome +01:00
Sarajevo +01:00
Skopje +01:00
Stockholm +01:00
Vienna +01:00
Warsaw +01:00
West Central Africa +01:00
Zagreb +01:00
Zurich +01:00
Athens +02:00
Bucharest +02:00
Cairo +02:00
Harare +02:00
Helsinki +02:00
Istanbul +02:00
Jerusalem +02:00
Kyiv +02:00
Pretoria +02:00
Riga +02:00
Sofia +02:00
Tallinn +02:00
Vilnius +02:00
Baghdad +03:00
Kuwait +03:00
Minsk +03:00
Moscow +03:00
Nairobi +03:00
Riyadh +03:00
St. Petersburg +03:00
Volgograd +03:00
Tehran +3:30
Abu Dhabi +04:00
Baku +04:00
Muscat +04:00
Tbilisi +04:00
Yerevan +04:00
Kabul +4:30
Ekaterinburg +05:00
Islamabad +05:00
Karachi +05:00
Tashkent +05:00
Chennai +5:30
Kolkata +5:30
Mumbai +5:30
New Delhi +5:30
Sri Jayawardenepura +5:30
Kathmandu +5:45
Almaty +06:00
Astana +06:00
Dhaka +06:00
Novosibirsk +06:00
Urumqi +06:00
Rangoon +6:30
Bangkok +07:00
Hanoi +07:00
Jakarta +07:00
Krasnoyarsk +07:00
Beijing +08:00
Chongqing +08:00
Hong Kong +08:00
Irkutsk +08:00
Kuala Lumpur +08:00
Perth +08:00
Singapore +08:00
Taipei +08:00
Ulaanbataar +08:00
Osaka +09:00
Sapporo +09:00
Seoul +09:00
Tokyo +09:00
Yakutsk +09:00
Adelaide +9:30
Darwin +9:30
Brisbane +10:00
Canberra +10:00
Guam +10:00
Hobart +10:00
Magadan +10:00
Melbourne +10:00
Port Moresby +10:00
Solomon Is. +10:00
Sydney +10:00
Vladivostok +10:00
New Caledonia +11:00
Auckland +12:00
Fiji +12:00
Kamchatka +12:00
Marshall Is. +12:00
Wellington +12:00
Nuku’alofa +12:00
Samoa +12:00
Tokelau Is. +13:00
Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us