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


Join eOne Solutions for the Q3 Partner All Hands Call!
SmartList Trek: SmartList Builder, Popdock & Your Future - New Popdock Trainings, August 2022
See eOne's Winning Virtual Integration for Salesforce
2022 Q3 Promotions
New Features & Updates in SmartConnect 21 - Recording Now Available!

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 Partner All Hands Call Popdock promotions release 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.