Leap Year Rules

Leap Year Rules

One of the trickier parts of handling date values is dealing withleap years. Everyone knows that every fourth year is a leap yearin which February has 29 days instead of the typical 28. Whatis less known is that there are two more rules to check to determinewhether a given year is a leap year or not:

  • Years that are evenly divisible by 100 are not leapyears;
  • Years that are evenly divisible by 400 are leap years.

With that in mind, I wrote this function to test whether any

given year is a leap year:

 Function IsLeap (iYear As Integer) _        As Integer        'Set Default Value        IsLeap = False        'Check the 400 Year rule        If (iYear Mod 400 = 0) Then                IsLeap = True                GoTo IsLeap_Exit        End If        'Check the 100 Year rule        If (iYear Mod 100 = 0) Then        IsLeap = False        GoTo IsLeap_Exit        End If        'Check the 4 Year rule        If (iYear Mod 4 = 0) Then        IsLeap = True        Else        IsLeap = False        End IfIsLeap_Exit:End Function

(Note: This is the VB3 version. For VB4 substitute a Boolean returnvalue for the function.)

Share the Post:
Heading photo, Metadata.

What is Metadata?

What is metadata? Well, It’s an odd concept to wrap your head around. Metadata is essentially the secondary layer of data that tracks details about the “regular” data. The regular

XDR solutions

The Benefits of Using XDR Solutions

Cybercriminals constantly adapt their strategies, developing newer, more powerful, and intelligent ways to attack your network. Since security professionals must innovate as well, more conventional endpoint detection solutions have evolved

AI is revolutionizing fraud detection

How AI is Revolutionizing Fraud Detection

Artificial intelligence – commonly known as AI – means a form of technology with multiple uses. As a result, it has become extremely valuable to a number of businesses across

AI innovation

Companies Leading AI Innovation in 2023

Artificial intelligence (AI) has been transforming industries and revolutionizing business operations. AI’s potential to enhance efficiency and productivity has become crucial to many businesses. As we move into 2023, several

data fivetran pricing

Fivetran Pricing Explained

One of the biggest trends of the 21st century is the massive surge in analytics. Analytics is the process of utilizing data to drive future decision-making. With so much of

kubernetes logging

Kubernetes Logging: What You Need to Know

Kubernetes from Google is one of the most popular open-source and free container management solutions made to make managing and deploying applications easier. It has a solid architecture that makes