The basics
Surround your date values with pound signs (#). For example, #4/1/1997#. Also, keep logical operators outside pound signs.
- #4/1/1997# Or #5/4/1997#
- >=#5/4/1997# Or <=#6/12/1998#
Filter for a given year
=Year([Acquired Date]), then put the year you want to filter for in the Criteria row.
Filter for an interval (year, quarter, etc.)
=DatePart("q",[acquired date]). In this example, put the numbers 1-4 (the quarter you want to filter for) in the Criteria row.
Subtract dates
=DateDiff("d",[RequiredDate],[ShippedDate]). Finds the days between a required date and a shipped date.
Add dates
=DateAdd("m",6,"4/1/1997") Finds 6 months of data, starting with the date provided.
DatePart, DateDiff, & DateAdd interval settings
| Setting | Description |
|---|---|
| yyyy | Year |
| q | Quarter |
| m | Month |
| y | Day of year |
| d | Day |
| w | Weekday |
| ww | Week |
| h | Hour |
| n | Minute |
| s | Seconds |