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


Popdock Data Lake Upload Tool for Dynamics NAV Data - FREE TRAINING
US Office Closed, Memorial Day - May 29, 2023
Accessing Historical Dynamics GP Data in NetSuite: The Azure Data Lake
New Webinar Series: What is the Azure Data Lake?
UPCOMING WEBINAR: Top 10 New Popdock Features

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 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 Zendesk

Integrate & Automate without Any Code.

SmartList Data has Never Been Faster.

The Easiest Way to Report on GP Data.