পৃষ্ঠাসমূহ

Search Your Article

CS

 

Welcome to GoogleDG – your one-stop destination for free learning resources, guides, and digital tools.

At GoogleDG, we believe that knowledge should be accessible to everyone. Our mission is to provide readers with valuable ebooks, tutorials, and tech-related content that makes learning easier, faster, and more enjoyable.

What We Offer:

  • 📘 Free & Helpful Ebooks – covering education, technology, self-development, and more.

  • 💻 Step-by-Step Tutorials – practical guides on digital tools, apps, and software.

  • 🌐 Tech Updates & Tips – simplified information to keep you informed in the fast-changing digital world.

  • 🎯 Learning Support – resources designed to support students, professionals, and lifelong learners.

    Latest world News 

     

Our Vision

To create a digital knowledge hub where anyone, from beginners to advanced learners, can find trustworthy resources and grow their skills.

Why Choose Us?

✔ Simple explanations of complex topics
✔ 100% free access to resources
✔ Regularly updated content
✔ A community that values knowledge sharing

We are continuously working to expand our content library and provide readers with the most useful and relevant digital learning materials.

📩 If you’d like to connect, share feedback, or suggest topics, feel free to reach us through the Contact page.

Pageviews

Thursday, February 9, 2017

VBA - Date-Time Function

VBScript Date and Time Functions help the developers to convert date and time from one format to another or to express the date or time value in the format that suits a specific condition.

Date Functions

S.No. Function & Description
1 Date A Function, which returns the current system date.
2 CDate A Function, which converts a given input to date.
3 DateAdd A Function, which returns a date to which a specified time interval has been added.
4 DateDiff A Function, which returns the difference between two time period.
5 DatePart A Function, which returns a specified part of the given input date value.
6 DateSerial A Function, which returns a valid date for the given year, month, and date.
7 FormatDateTime A Function, which formats the date based on the supplied parameters.
8 IsDate A Function, which returns a Boolean Value whether or not the supplied parameter is a date.
9 Day A Function, which returns an integer between 1 and 31 that represents the day of the specified date.
10 Month A Function, which returns an integer between 1 and 12 that represents the month of the specified date.
11 Year A Function, which returns an integer that represents the year of the specified date.
12 MonthName A Function, which returns the name of the particular month for the specified date.
13 WeekDay A Function, which returns an integer(1 to 7) that represents the day of the week for the specified day.
14 WeekDayName A Function, which returns the weekday name for the specified day.

Time Functions

S.No. Function & Description
1 Now A Function, which returns the current system date and time.
2 Hour A Function, which returns an integer between 0 and 23 that represents the hour part of the given time.
3 Minute A Function, which returns an integer between 0 and 59 that represents the minutes part of the given time.
4 Second A Function, which returns an integer between 0 and 59 that represents the seconds part of the given time.
5 Time A Function, which returns the current system time.
6 Timer A Function, which returns the number of seconds and milliseconds since 12:00 AM.
7 TimeSerial A Function, which returns the time for the specific input of hour, minute and second.
8 TimeValue A Function, which converts the input string to a time format.

No comments:

Post a Comment