Pacific Database

Home | Contact | FAQs | View Cart

A world of information at your fingertips

Date & Time :: Milestone functions

On this page you will find several functions for determining calendar milestones.

Leap year

    myBool = (Month(DateSerial(Year(dte), 2, 29)) = 2)

Week day

    myBool = (WeekDay(Dte, vbMonday) < 7)

Weekend

    myBool = (WeekDay(Dte, vbMonday) > 5)