In February, we learned how to work with dates in formulas and filters.

Timestamps

00:15 Answering sign-up questions: date ranges in summary tables
06:26 Webinar Intro
06:48 Date and datetime columns, and formatting them
08:58 Filtering date and datetime columns – absolute and relative filters
11:08 Extracting month and year from dates and summarizing dates data
17:34 Extracting time from datetime columns
20:28 Timestamping records with trigger formulas – NOW() v TODAY()
22:59 Using DATEADD() in formulas, with TODAY()
26:22 When to use a spreadsheet function v. python?
27:13 How to find the earliest or latest date in a list?

Links

• Date ranges and summary tables: https://community.getgrist.com/t/creating-a-summary-table-based-on-multiple-date-ranges/2137
• Credit Card Activity Template: https://templates.getgrist.com/2i9WoHs2oRzK/Credit-Card-Activity-Template-AmEx
• Simple Time Tracker Template: https://templates.getgrist.com/np7TVHmuvFcH/Simple-Time-Tracker
• Team Meetings Organizer Template: https://templates.getgrist.com/4vTwsstWA6uQ/Team-Meetings-Organizer
• Grist Function reference: https://support.getgrist.com/functions/
• Python strftime() method: https://docs.python.org/3/library/datetime.html#strftime-and-strptime-behavior
• DATEADD: https://support.getgrist.com/functions/#dateadd
• Sprouts: https://www.getgrist.com/sprouts-program/
• Community Forum: https://community.getgrist.com/