75

I've looked under insert > ...? but couldn't find anything.

Can this be done via an inbuilt function or a custom script?

  • 11
    I'm shocked that Google Docs doesn't already have this feature. It seems like one of the most basic things that modern word processors should have. – L S Mar 12 '15 at 16:54
  • If you need it for spreadshetts paste =TODAY() in cell. I know question about google-docs. But first in google if google for spreadshets. – Fortran Nov 20 '17 at 11:30
  • "=TODAY()" works great – Jackssn Jun 24 '18 at 14:42
  • =TODAY() doesnt work for logging, since it will update to the current date everytime the page is opened. Most times I want to record todays date and not update. If you need to insert todays date for a log file, then you need something else. – Hephaestus Aug 7 at 18:43
66

It’s possible to insert todays date through a macro.

Open your Google Document and under Tools select Script editor. This opens Google's script editor where it’s possible to create macros for Google Documents.

Paste this script and save it as Date Macro or something: (also available here)

/**
 * The onOpen function runs automatically when the Google Docs document is
 * opened. Use it to add custom menus to Google Docs that allow the user to run
 * custom scripts. For more information, please consult the following two
 * resources.
 *
 * Extending Google Docs developer guide:
 *     https://developers.google.com/apps-script/guides/docs
 *
 * Document service reference documentation:
 *     https://developers.google.com/apps-script/reference/document/
 */
function onOpen() {
  // Add a menu with some items, some separators, and a sub-menu.
  DocumentApp.getUi().createMenu('Utilities')
      .addItem('Insert Date', 'insertAtCursor')
      .addToUi();
}

/**
 * Inserts the date at the current cursor location in boldface.
 */
function insertAtCursor() {
  var cursor = DocumentApp.getActiveDocument().getCursor();

  if (cursor) {
    // Attempt to insert text at the cursor position. If insertion returns null,
    // then the cursor's containing element doesn't allow text insertions.
    var date = Utilities.formatDate(new Date(), "GMT", "yyyy-MM-dd"); // "yyyy-MM-dd'T'HH:mm:ss'Z'"
    var element = cursor.insertText(date);
    if (element) {
      element.setBold(true);
    } else {
      DocumentApp.getUi().alert('Cannot insert text at this cursor location.');
    }
  } else {
    DocumentApp.getUi().alert('Cannot find a cursor in the document.');
  }
}

Now refresh or reopen your document and a new menu item appears: Utilities. Under this menu an item appears called Insert Date. Click that to insert todays date at your cursor position.

To change the format of the date you need to change the “format” used in the script. The format can contain the following characters: yyyy-MM-dd'T'HH:mm:ss'Z'

To clarify, this script merely inserts today's date at the cursor location for the day you execute the utility. That's not precisely the same as the =today() function in Google Sheets, which updates the date to the current date whenever you open the spreadsheet. However, this script will save you the trouble of looking up the date and typing it on the day that you execute the script.

  • 1
    This is now found under Tools > Script Editor... – Mir Jul 2 '14 at 17:39
  • 2
    It defaults to "GMT". If you look at the line containing: Utilities.formatDate(new Date(), "GMT", "yyyy-MM-dd"); it's possible to change GMT to a timezone of choice. – Thomas Wiersema Mar 23 '15 at 14:19
  • 1
    I've made a similar function for SpreadsheetApp (to insert date in active cell). You can find it here: gist.github.com/Eccenux/712ae3d7913e971e46035546b2ccc85b – Nux Nov 21 '16 at 11:23
  • 1
    Now.. is there some way to automatically force a script to be inserted into all documents created in an organization? – Michael Mar 28 '18 at 18:14
  • 1
    Is there any way to make this script "global" so that for every Google Doc I create or open, the script is there and accessible? – Taptronic Aug 23 at 13:41
1

If you are willing to use a 3rd party program, I use Dash - http://kapeli.com/dash - with a Date and Time snippet. It auto replaces your snippet (mine is 'datetime') with the current date and time. This works system wide.

Dash is only available for OS X and iOS.

  • 1
    Dash doesn't look to work with Google Documents. – Rubén Aug 6 '15 at 2:34
  • @Rubén - I just checked. It works great. You have to type your shortcut. For example I have @@ for my email. Once you type that Dash replaces it with your text. – Joshua Dance Aug 11 '15 at 18:03
  • Google Documents is not listed in the linked page in your answer, by the other hand, looks that Dash is only available for OS X and iOS. Do you know if it's available for other OS? – Rubén Aug 11 '15 at 22:01
  • 1
    @Rubén - the list is the programming API docs that come loaded in Dash. Dash works anywhere text entry works. And there are similar auto complete programs available for other OS. – Joshua Dance Aug 12 '15 at 21:20
0

Here is my modified version for dating a letter head.

It prints out the current date like '14, August, 2015' in time zone "GMT+2" with font 'Cambria' in size 11.

See following:

function onOpen() {
  // Add a menu with some items, some separators, and a sub-menu.
  DocumentApp.getUi().createMenu('Utilities')
      .addItem('Insert Date', 'insertAtCursor')
      .addToUi();
}

// Inserts the date at the current cursor location.
function insertAtCursor() {

  var cursor = DocumentApp.getActiveDocument().getCursor()


  if (cursor) {
    // Attempt to insert text at the cursor position. If insertion returns null,
    // then the cursor's containing element doesn't allow text insertions.
    var dMy = Utilities.formatDate(new Date(), "GMT+2", "dd, MMMMM, yyyy"); 
    var element = cursor.insertText(dMy);
    if (element) {
     element.setFontSize(11).setFontFamily('Cambria');                       
    } else {
      DocumentApp.getUi().alert('Cannot insert text at this cursor location.');
    }
  } else {
    DocumentApp.getUi().alert('Cannot find a cursor in the document.');
  }
}
0

Forget macros. Just link to a cell in Google Sheets!

  1. Go to Google Sheets.
  2. Create a new Google Sheets spreadsheet and name it something like "Today."
  3. In a cell in that spreadsheet, type the following: =TODAY()
  4. Select that cell along with an adjoining cell (which makes it a Table and not just text). Copy the selected cells (using "Edit" --> "Copy" or a keyboard shortcut).
  5. Open a Google Doc or a Google Slideshow and paste the table wherever you'd like for the current day's date to appear.

Voila!

  • 4
    Thanks @geekzspot - you mention 'cell' so i presume your talking about a google drive spreadsheet do you know if theres a way to do this in a google drive word document ? – sam Apr 9 '14 at 8:36
  • Yes, this is for spreadsheets. I've made it clearer. Sorry, this doesn't work in a document – geekzspot Aug 28 '14 at 1:47

protected by Community Jul 3 '16 at 18:28

Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).

Would you like to answer one of these unanswered questions instead?

Not the answer you're looking for? Browse other questions tagged or ask your own question.