Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

subtract 21 days from Today's date

Status
Not open for further replies.
CHTHOMAS

CHTHOMAS

Programmer
Jun 16, 1999
106
AE
Hi,

How to subtract 21 days from Today's date? I tried something like DateDiff("d",Date(),21), but getting unexpected numbers.

Regards,

Charley
 
Sort by date Sort by votes
How about :=
Code: 
Dim DteVal as Date

DteVal = (Date()- 21)

Steady ... [thumbsup2]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

OCM
  • Locked
  • Question
Populate access table from excel
Replies
6
Views
5K
OCM
OCM
Moss100
  • Locked
  • Question
Upgrading from Access 2013 - whats the best option
Replies
2
Views
3K
Moss100
Moss100
lmcate
  • Locked
  • Question
How to Open ACCESS (MDB) from an HTML Page 1
Replies
2
Views
4K
lmcate
lmcate
atadbitslow
  • Locked
  • Question
need help with syntax for a date
Replies
3
Views
409
dhookom
dhookom
EM1107
  • Locked
  • Question
populate a column with time from other column.
Replies
1
Views
342
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top