Deafult the Date / Time

A

amfroehlich

Board Regular
Joined
Jul 14, 2004
Messages
192
I have a date time field that i would like the default value to be one week a head of the current date and time. How can i accomplish this?
 

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).
Sort by date Sort by votes
How about using this for the default value property:

DateAdd("ww",1,Now())
 
Upvote 0
You must log in or register to reply here.

Similar threads

M
  • Question
Access vba code to pass variable date via SendKeys
Replies
2
Views
318
moorecurls
M
C
  • Solved
Access Querry Seeking Records that has 0 usage in Three Consecutive Months
Replies
5
Views
467
Chris101
C
A
  • Question
Inventory and Product updates Update Database
Replies
4
Views
549
ankrups
A
CPGDeveloper
  • Solved
Validation of Field Value
Replies
7
Views
288
CPGDeveloper
CPGDeveloper
P
  • Solved
expression value in table to return FY
Replies
8
Views
504
Joe4
Joe4

Forum statistics

Threads
1,221,814
Messages
6,162,132
Members
451,743
Latest member
matt3388

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top