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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Simple date question!

Status
Not open for further replies.
99mel

99mel

Programmer
Oct 18, 1999
379
GB
Just a simple one here,&nbsp;&nbsp;all i'm wanting is the current year in the format yyyy (data got from the system).&nbsp;&nbsp;I've had a look at the Format Function but can't find anything for this.<br><br>Thanks<br><br>Mel
 
Sort by date Sort by votes
x = format(now,&quot;mm/dd/yyyy&quot;)<br>Keep in mind that if you send this to a database like Access and you view it in the database it may be set to just 23 digits for the year. Which will truncate or manipulate the date to 00/00/00.<br><br>OK<br>
 
Upvote 0 Downvote
You almost had it!<br><br>MsgBox = Format(Now, &quot;yyyy&quot;)<br>
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

sal21
  • Locked
  • Question
SORT DATE in msflexgrid not correct
Replies
4
Views
303
sal21
sal21
2009luca
  • Locked
  • Question
GET date from classname
Replies
2
Views
498
2009luca
2009luca
Swi
  • Locked
  • Question
Date/Time Conversion 1
Replies
2
Views
320
Swi
Swi
sal21
  • Locked
  • Question
LAST DATE OF MODIFIED FILE on WEB 1
Replies
4
Views
376
strongm
strongm
sal21
  • Locked
  • Question
DRAG AND DROP question. 1
Replies
5
Views
372
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top