Date Parameters

[edmac2]

Using NEILSON's Post to my previous question I get a begin date and an end date. How do I use these 2 dates to search for any date that falls between these 2 parameter fields. If I delete these 2 parameter fields Crystal shows all the dates and info but when I put these 2 parameters back in I get absolutely nothing meaning I am somehow useing these 2 fields wrong in my search formula? I ask it to search with the following criteria <br>{MATUSETRANS.TRANSDATE} &gt;= {@Start Date} and<br>{MATUSETRANS.TRANSDATE} &lt;= {@Finish Date}<br>So it searches for any date between the 2 dates.

 

[LindaC]

Your logic is correct but where are you putting this formula?&nbsp;&nbsp;You need to select the Report Menu, then Edit Selection Formula, then Record.&nbsp;&nbsp;If this is where it is, are you sure there is data for the dates you are picking?&nbsp;&nbsp; <p>LindaC<br><a href=mailto:lcastner@co.orange.ny.us>lcastner@co.orange.ny.us</a><br><a href= > </a><br>

 

[edmac2]

Thanks Neilson and Linda, I finnaly got it, I had my dates from the field formated for 5/15/00 instead of 5/5/2000 and it must have made a difference.

 

[Nilsen]

On my date formula's I use the &quot;In&quot; function:<br>{MATUSETRANS.TRANSDATE} In {@Start Date} to {@End Date}.<br><br>It does the same thing as your formula, just looks a little cleaner.&nbsp;&nbsp;(My opinion anyway).<br><br>Also, FYI...<br>The reason the format 5/15/00 wouldn't work and 5/5/2000 would in the date formula I gave you is that the formula only checked to see if the month and the day are 1 or 2 digits.&nbsp;&nbsp;It didn't check the year if it is 2 or 4 digits.&nbsp;&nbsp;It required a 4 digit year on that formula.