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';
InitialValues.Add('@FromInvoiceDate=<'''+
FormatDateTime('mm"/"dd"/"yy', StartDate)+'''>');
InitialValues.Add('@ToInvoiceDate=<'''+
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.