Welcome, Guest
  • Page:
  • 1
  • 2

TOPIC: Automatically figuring start of FY?

Automatically figuring start of FY? 15 Jul 2009 11:39 #31263

  • DrewAllen
  • OFFLINE
  • Platinum Boarder
  • Posts: 1379
  • Karma: 1
I use this for the FY calculation,

Year( DateAdd("q", 2, GiftDate) )

WARNING: check the syntax for this. Access, SQL, and Crystal all have this formula, but they each have their own idiosyncratic syntax.

Drew
J. Drew Allen

Crystal Reports and SQL Server Consultant




It is better to live your destiny imperfectly than to live an imitation of somebody else's life with perfection.

Automatically figuring start of FY? 16 Jul 2009 04:08 #31276

  • jas.
  • OFFLINE
  • Platinum Boarder
  • Posts: 881
  • Karma: 4
wow, thanks all. I'll give these various things a shot, and probably will be back with more questions later!
james andrews
director of development services
philadelphia museum of art
  • Page:
  • 1
  • 2
Time to create page: 0.46 seconds