Skip to content
+1-888-319-3663

EONE BLOG

Leap Year


The SmartConnect scheduling service was caught out by the 29th February 2012. That wonderful leap year event that only comes around every four years.  For those that found their scheduled integrations either stopped or got excited and ran every minute  – I apologise and you will find this KB article here will resolve any ongoing issues.

Reset schedules for leap year.

At eOne we were also caught out on the 29th – with our scheduled maps failing to run.  Our dev guys were also working on some scheduling code on the 29th and spent 1/2 a day trying to work out why things were not running on the 29th when it had been perfect on the 28th!

This is something that should not have happened, but is a result of me saying about three years ago ‘we need to get this code released this week – worry about leap years in the next build’. We discovered last week that we never remembered to come back to this task.

Rest assured that by February 29th 2016 – that this issue will be resolved.

1 Comment

  1. BrianG on March 12, 2012 at 2:12 pm

    I found this post helpful for Leap Year detection:
    http://blog.sqlauthority.com/2012/03/03/sql-server-various-leap-year-logics/

    IIF((@Year%4=0 AND @Year%100 != 0) OR @Year%400=0, 1,0)

Leave a Comment





RECENT POSTS


eOne at Summit North America 2021
Employee Spotlight: Megan Tripp, Business Development Representative
eOne is now compatible with Microsoft Dynamics GP October 2021 Release
October 2021 Releases of Extender, SmartList Builder, SmartView, SmartPost, and Flexicoder are Now Available
Advanced SmartConnect REST Web Services Integration - October 2021

POPULAR POSTS


2016 SmartConnect Integration Bootcamps
Tech Tues: Automatically refreshing Pivot Tables in Excel Refreshable Reports
Happy Thanksgiving from the eOne team!
2017 SmartConnect Integration Bootcamps
New Releases of Extender and SmartList Builder

CATEGORIES

TAGS

Business Central CRM D365 Business Central Dynamics 365 dynamics crm Dynamics GP Dynamics NAV Econnect Employee Spotlight eone eOne News error Error Message Events Excel Excel Report Builder Extender Flexicoder GP integration Map Meet the Team Microsoft dynamics crm Microsoft Dynamics GP Navigation List Builder Office Relationships partners Popdock release Reporting SalesForce SalesForce.com SmartConnect SmartConnect.com SmartConnect Bootcamp SmartConnect Maps SmartConnect Office Hours SmartList SmartList Builder SmartPost SmartView SQL Tech Tuesday Templates training

Integrate & Automate without Any Code.

SmartList Data has Never Been Faster.

The Easiest Way to Report on GP Data.