Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

yearly comparative reports and leap year issues

Status
Not open for further replies.

JSHoltsIT

IS-IT--Management
Joined
Apr 12, 2007
Messages
66
Location
US
I have a portion of a select formula

{AAcsbycpi.glpostdt} >= Date(Year(Maximum({?Date Range}))-1,1,1)

that gives me everything from the current and previous year in my report. I received word that February data for this year and last are off. I presume this is a leap year issue?

Thanks

Jason
 
That particular part of the formula should not cause a problem, since it is only testing against January 1.

-LB
 
Thanks for the sanity check.

Jason
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top