hii all,

i have a problem with my report.
i was try passing my date parameter from variabel to formula

Report.FormulaFields.GetItemByName("s-date").Text = "#" & Format(sdate, "mm/dd/yyyy") & "#"

Report.FormulaFields.GetItemByName("e-date").Text = "#" & Format(edate, "mm/dd/yyyy") & "#"

NB:
s-date & e-date = formula that retrun date value
sdate & edate = variable in VB 6

the value that i was passing could work well in the report operation but s-date & e-date format (dd/mm/yyyy) become dd/mm/yyy HH:MM:SS.

although i was format the s-date & e-date (in CR 8.5) to dd/mm/yyyy type, it have no effect.

does any one have a suggestion?