Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help entering entering dates as parameters 1

Status
Not open for further replies.

george1

Technical User
Jul 31, 2000
2
AU
I have created a report that works fine under report designer. <br>It accepts a start and end date as a parameter in the format - date(2000, 07, 01), completes successfully and also prints the dates correctly on the page.<br>But when I run the same report from Info Desktop, no records are selected and the dates are blank on the report.<br>This is how on-line help tells me I should enter dates as parameters.<br>Any help would be greatly appreciated.
 
I've had problems with date parameters - I used strings instead and cast them as dates. <p>Malcolm Wynden<br><a href=mailto:wynden@island.dot.net>wynden@island.dot.net</a><br><a href= > </a><br>
 
It is silly but my date parameter only works correclty when I use capital D as in Date(2000,01,30)<br>
 
I think I stick with strings till they get the code worked out.&nbsp;&nbsp;After all, it hasn't worked right for 4 versions, but it is getting better, so maybe by V12.... <p>Malcolm Wynden<br><a href=mailto:wynden@island.dot.net>wynden@island.dot.net</a><br><a href= > </a><br>
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top