Passing date variable to Report Smith in dd/mm/yy format 
Author Message
 Passing date variable to Report Smith in dd/mm/yy format

Hi,

I've been trying without any success to pass date variables to Report
Smith in dd/mm/yy format. Things work if the date is pass as mm/dd/yy
with the following code:

        with BCReport do
        begin
                InitialValues.Clear;
            ReportName := 'ISALESUM.RPT';

                                           FormatDateTime('mm"/"dd"/"yy', StartDate)+'''>');

                                           FormatDateTime('mm"/"dd"/"yy', EndDate)+'''>');
            Run;
        end;

bt changing FormatDateTime('mm"/"dd"/"yy', EndDate) to
FormatDateTime('dd"/"mm"/"yy', EndDate) raises an error.

Is there anyway to make sure that the date be passed in dd/mm/yy
format hence be printed in the same format as well, which is my main
concern. I've made sure that the Windows date format and the BDE date
format are all in dd/mm/yy.

Please help! If possible, please email your reply as my ISP do not
keep newsgroup message for more than a few days. If anyone else is
interested, i'll compile the reply I receive and post to this
newsgroup. Thanks.



Fri, 15 Jan 1999 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Date problems dd/mm/yyyy mm/dd/yyyy in Access

2. Date format dd-mm-yyyy

3. Passing variable to Report Smith

4. Report Smith and report variables

5. REPORT VARIABLE: REPORT SMITH

6. Report Smith & Report variables

7. mm/dd/yyyy problems (some more)

8. Passing Report Variables from the Master to Detail Reports

9. Report Smith Variables

10. Report Smith Variables

11. How to pass two dates to a query tbl into a quick report form

12. Report variable and dates

 

 
Powered by phpBB® Forum Software