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

Textbox with Date

Status
Not open for further replies.

camelk

Technical User
Mar 19, 2002
26
US
In the header of the report, I want to put a text box that shows "year to date" (i.e., 01/01/02 thru 04/15/02). How do I do this? Thanks
camelk
 
Just build it up as text, e.g.
set the rowsource to:
=format$(&quot;#1/1/&quot;& datepart(&quot;yyyy&quot;,now) &&quot;#&quot;,<whatever date format>)&&quot; through &quot;& format$(now,<whatever date format>)

success! [smarty]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top