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!

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

Using DatePart "d" in a date field

Status
Not open for further replies.

Geekette

MIS
Jun 5, 1999
27
0
0
US
I want to be able to enter, for example "17", in a date field and have that converted to the current month and year (e.g. 17 Dec 1999). Any suggestions?
 
Hiya Geekette,<br>
<br>
This is as far as I got on your question. Used as a control source for a control, it results in a date formatted control.<br>
<br>
Month(Now()) & &quot;/&quot; & [Form control Name] & &quot;/&quot; & Year(Now())<br>
<br>
Hope this helps!<br>
Drew
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top