How do I Get future date (1 Viewer)

S

smiler44

Registered User.

Local time

Today, 07:51

Joined

Jul 15, 2008

Messages

641

• Sep 22, 2011

• #1

How do I get a future date?
Monday to Friday is my working week.
I want the date of "today" next week
I am rubbish with funtions, so if it is a function please could you supply the whole funtion/ code that i can attach to a command button?

Thank you

smiler44

 

boblarson

Smeghead

Local time

Yesterday, 23:51

Joined

Jan 12, 2001

Messages

32,059

• Sep 22, 2011

• #2

If you just want the date 7 days from now you can use

Date() + 7

or

DateAdd("d", 7, Date())

or

DateAdd("ww", 1, Date())

 

S

smiler44

Registered User.

Local time

Today, 07:51

Joined

Jul 15, 2008

Messages

641

• Sep 22, 2011

• #3

Bob Larson, I've got to say you are a genius. Thanmk you.
You have given me such a simple reply. what I found on the web I could not undertsand.

Thank you so very much

smiler44

 

S

smiler44

Registered User.

Local time

Today, 07:51

Joined

Jul 15, 2008

Messages

641

• Sep 24, 2011

• #4

Bob,
still getting the date 7 days or so from now, is there an easy way with the code you gave me have the date in the format of dd/mm/yy?

Thanks
smiler44

 

boblarson

Smeghead

Local time

Yesterday, 23:51

Joined

Jan 12, 2001

Messages

32,059

• Sep 26, 2011

• #5

Format(DateAdd("d", 7, Date()), "dd/mm/yy")

 

S

smiler44

Registered User.

Local time

Today, 07:51

Joined

Jul 15, 2008

Messages

641

• Sep 27, 2011

• #6

Bob, thank you very much.


smiler44