In VB coding how to add one to date?

Asked By kurt pry 0 points N/A Posted on - 12/19/2012

In starting a program in Visual Basic I want my dates to be compatible with World Time Zone.

In VB coding how to add one to date and allow functionality in Access?

If it doesn't work for Access, will Excel?

• Status: Open
• Question Views: 860
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Visual basic

Answered By Schneider Matthew 0 points N/A #181450

In VB coding how to add one to date?

Hi Kurt Pry,

You can use DateAdd function in VB script to add dates.

 

Below is the syntax for the same.

 

DateAdd ( Timeinterval, value, date )

 

Timeinterval can be of the following types.

 

yyyy – Year

q – Quarter

m – Month

y – Day of the year

d – Day

w – Weekday

ww – Week

h – Hour

n – Minute

s – Second

 

Value is the interval you want to add

date is the date to which value will be added

 

It can be used in VB script

below is a sample code.

 

Dim NewDate As Date

 

NewDate = DateAdd ("n", 53, #29/10/2012 10:31:58 AM#)

 

It is applicable to all versions of Access.

 

Hope it helps.

About Schneider Matthew

Questions
3

Answers
107

Best Answers
23

• Vote Up 0 Vote Down

• Posted on - 01/22/2013
• Question Category: Visual basic