By using this web site, you agree to all terms and conditions for acceptable use.

ServiceLedger KnowledgeBase Knowledgebase Home Page > ServiceLedger | Contact Us

Search the Knowledge Base Browse by Category

ServiceLedger provides this content as-is for self help support purposes. ServiceLedger assumes no liability for any steps you take based on the directions in our knowledge base, and assumes that you have the knowledge to determine whether a given step is appropriate for your situation. Certain solutions can affect third-party software that ServiceLedger relies on or integrates with; it is your responsibility to consult with the documentation or publishers of such third-party software to understand whether any changes suggested here will have negative effects on other applications.

(Internal) Leap Year Warranty Fix

Would you like to...

Print this page
Email this to a friend


During leap years, the number of days on the default warranty for items sold (365) calculates to one day earlier during the following year instead of the same date on the next year.

If a customer needs to change this and maintains support, we can offer to set all of their items that have a 365 day warranty to have a 366 day warranty for the duration of the leap year, and then (assuming they still have support) set it back to 365 days when the next year rolls around.

!!! Back up the database before running any SQL modifications !!!

SQL to update 365 day warranties to 366 days:

update item set warranty = 366 where warranty = 365

SQL to update 366 day warranties to 365 days:

update item set warranty = 365 where warranty = 366

If a customer has 2 or 3 year warranties and you want to do the math and they have support, you can adjust the SQL accordingly for those as well. If you have to get a developer involved, it will be billable services.

Note that these changes only affect newly added line items moving forward. To fix line items that were already entered, just adjust the warranty expiration date manually.

Related Questions:


No attachments were found.

ServiceLedger KnowledgeBase Copyright © 2020
Powered by AcitveKB Knowledgebase Software