I hope that someone gives me an answers. I have a simple database and one field is date type. All I need is show a report between to dates. This dates are collected from the user in two text box<br>I been trying with cr4.5, DRD and I use VB6<br>Thank you
You do this by creating a parameter field (name it report dates or something else appropriate). For the prompt, put something like "Enter Date Range". After creating the parameter field, insert it into the report, and then when the report runs, you will be prompted to put in the start and end date.
Because you are getting the dates in string format (not the easiest way to do it, but reliable), you will also have to convert the strings to dates.<br>The format for dates in Crystal is DATE(YYYY,MM,DD) where YYYY, MM, DD are integers. So if your parameter is a string in the format "2000/02/24", you would convert this to a date in a Crystal formula by extracting the integer values for the date from the string.<br>DATE(ToNumber(?FromDate[1 to 4],0), ToNumber(?FromDate[6 to 7],0), ToNumber(?FromDate[9 to 10],0))<br><br> <br> <p>Malcolm Wynden<br><a href=mailto:wynden@island.dot.net>wynden@island.dot.net</a><br><a href= > </a><br>
Following up on this....How can I print the start and end values of a date range? I tried the 'special field' and inserted the 'record selection' one but this just prints the formula, if you will, rather than the values. Can someone help?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.