[AccessD] Date within this quarter?

Chris,

  If fiscal, then you need to compare it against a table loaded with the
periods.  If strictly calendar then:

  If Datepart("q",<my Date>) = <some quarter> then
  End If


  Optional arguments are first day of year and first day of week.

Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Christopher
Hawkins
Sent: Tuesday, January 04, 2005 4:46 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Date within this quarter?


Hello all.  Fun VBA question here.

 Given a date, how would you determine if it fell within the current
calendar quarter?

 -Christopher-


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com