Tip o’ the Week 396 – Handling dates in Office apps

clip_image002There are many times when you may need to deal with dates in ordinary applications – and there are a few shortcuts that you can make it easier.

In Outlook, any time there’s a date field (like when you’re setting a reminder, or clip_image004entering the start date/time for an appointment) you can choose or enter a regular date, or put in an expression – like “2 days” or “next Tuesday” – and Outlook will figure out the offset from today, and will set the appropriate date.

In some date fields (like an appointment start time), if you say “4 days” then press enter or TAB, it will evaluate the new date; if you return and put “4 days” again, it may add those extra days to the last date. Try a few other things like “next Christmas”, “3rd Sunday in November”, “2mo” , “7d” or some special days – there are some surprising ones there, like “Lincoln’s birthday”, and other events with static dates … though nothing that might change the actual date from year to year (like Easter, or Thanksgiving).

clip_image006In Excel, press CTRL+; to insert the current date into any cell – add a SHIFT key to insert the time instead. Excel are many date-oriented functions, but you don’t always need to write functions – simple maths can work on date fields – calculating the number of days’ difference between two dates, for example, or adding a number of days to a start date.

clip_image008In the desktop OneNote app, if you want to edit the date and time at the top of a page, click on the field and you’ll see a clock or calendar icon appear next to it – click on that  is set to, click on that to change the value; handy if you’re updating some reference material and want to make it clear that it’s recent.

Another way might be to insert the current date or time into the text: to do so, press SHIFT-ALT-D, or SHIFT-ALT-T for the current time, or SHIFT-ALT-F for the current date and time. The last one is really handy if you’re taking notes about a phone call, and want to quickly note the time that your insurance company said that everything was all fine, or when you started the indefinite call to the airline. The same shortcuts apply to the desktop OneNote 2016 application and also the OneNote store app.

clip_image010Word also supports SHIFT-ALT-D and SHIFT-ALT-T like OneNote, though inserts a date or time field rather than a simple bit of text, and is slightly different to the Date & Time command on the Insert tab, which gives a bit more control over the formatting at the point of insertion, rather than requiring the user to insert the field then go back in to edit the format.

Since Outlook uses Word as its text editor behind the scenes, the same shortcut keys will also insert date fields into the text of an Outlook email.

Tip o’ the Week 393 – Searching in OneNote

Tip o’ the Week OneNote. Both the full-fat trad Windows app version (OneNote 2016), and the Store (just “OneNote”) application that has a portion of the functionality and a simpler UI. One side effect of using OneNote a lot, though, is that you might have a huge  amount of old pages in your set of Notebooks, especially if you share notebooks with your team, and end up with a Notebook for each project you’re working on.

If you’re using the regular OneNote 2016 application, and go to search content (by entering the search term into the box on the top right, maybe by just pressing CTRL+E to jump straight to it), you may find that the results you get include a lot of old content which isn’t all that easy to parse – the name of the notebook occupies much of the column showing the location of the matching page or section, there’s no date of last update or any means of sorting – so it’s hard to know what’s recent and what might be years old.

If you click on “Pin Search Results” at the very bottom of the results list, or press ALT-O, then you’ll see the results appearing in a pane to the right of the OneNote window, where you can change sorting and filtering options, and see the date the pages were last modified.

Referring to this option as “Pin” may make you think it’s a bit more permanent (such as pinning to taskbar or Start, or pinning to a menu somewhere), but it’s as easy to dismiss the results pane as it is to invoke it in the first place – just click the X in the top right of the window pane, or the close option on the drop down arrow which also lets you resize the pane or even move/undock it from the main Outlook window altogether.

There’s no obvious equivalent of this search granularity in the OneNote store app.