Formula

K

KenP

I can use the below expression to display orders for the fourth calendar
quarter.

DatePart("q", [OrderDate])=4

The above formula performs the calculation and returns said orders for all
years existing in OrderDate field. If I wanted to use formula to display said
orders for a current year or a particular year such as 2004, how would I do
that?


Thanks in advance.
KP
 
D

Duane Hookom

You could add another section to the where clause like:

WHERE DatePart("q", [OrderDate])=4 AND Year([OrderDate]) =Year(Date())
 
Top