Date Format

SteveE

Registered User.
Local time
Today, 05:32
Joined
Dec 6, 2002
Messages
221
I have a simple report based on a query with only the two selection using the parameters of Between [From Date] and [to Date] if the selection is entered as i.e. 1/7 to 30/7 I want these two date to appear in the report heading- no problem here but is there a simple way of making the format appear as 01/07/2004 to 30/07/2004. In other words making the format change on the report? I have tried setting the format in the properties for these boxes but no matter what it is set to it still appears as entered in the query select parameters ?

thanks
 
In report textboxes properties for dates find format and type mm/dd/yyyy.
 
Thanks for the reply, but I am setting the text box properties in the report fields, but no matter what format type it is set to it still appears as entered in the query select parmaters (I know if the selected was based on a from I could specify the format but I am just seeing if I can get around that)

thanks
 

Users who are viewing this thread

Back
Top Bottom