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

How to display date as 020403 rather then 02/04/03? 2

Status
Not open for further replies.

ffleitas

Technical User
Mar 15, 2001
85
US
Hello programmers,

How to I display on a report a data date field as 020403 instead of 02/04/03?


Thanks,
Felix
 
Try this in the control source for you textbox.
=Format(DateField,"mmddyy")

Paul

 
ffleitas:

If Paul's suggestion doesn't work for you (I had trouble using the Format function in the Control Source Property), then try putting

mmddyy

in the Format Property of the Format tab of your textbox control. That worked for me.

Hope this helps,

Vic
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top