Subtracting Dates

[ABerkowicz]

Can someone offer help with the following?<br><br>My report has a parameter asking the user to enter a date.<br><br>I need my selection to only return records that are &lt;= 3 months from that parameter date. <br><br>(ie: parameter date 7/1/00 and I need records from 4/1/00 and prior)<br><br>Thank you.

 

[Guest_imported]

if you have CR#8 then the dateadd function is already built in other wise <br>find some help on Seagate software Knowledge base see article c2005641<br>Note:=======<br><br>If you have version 6 or 7 of Crystal Reports, to obtain the DateAdd function go to <A HREF="

http://support.seagatesoftware.com"

TARGET="_new">

http://support.seagatesoftware.com</A>.<br><br>·

Click 'Files/Updates', then click 'Find a file'.<br>· Search for UFLDateAdd.exe.<br><br>then it will be <br>DateAdd(&quot;M&quot;,-1, {Orders.OrderDate})<br>&nbsp;&nbsp;<br><br>