formula format (passing date from VB 6 to CR 8.5)
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=206
Printed Date: 04 May 2024 at 7:55pm
Topic: formula format (passing date from VB 6 to CR 8.5)
Posted By: dummies
Subject: formula format (passing date from VB 6 to CR 8.5)
Date Posted: 11 Feb 2007 at 7:49pm
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?
-------------
CR newbie
|
|