p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

crystal_reports thread: Re: Help with extracting a previous day data in Crystal Reports 8.5


Message #1 by "Anatoly Raklyar" <dmcub@y...> on Wed, 2 Oct 2002 21:42:34
> Hi,
>  
> Please, Please, needs immediate help with the syntax to extract previous 
day
> ONLY data when doing a report in 8.5.
> The built-in functions such as CurrentDate, or AllDatestoYesterday chosen
> as:
> Date({table.createdate}) =  CurrentDate - 1 gives no error but compiles
> wrong data.
> or
> Date({table.createtime}) = Date(CurrentDate - Date(1))) or day(1) gives 
no
> error but won't compile the right data either?
> or
> AllDatetoYesterday gives up to previous all dates but not just a previous
> day data alone.
>  
> How can i write codes to only get previous day data? there aren't a 
single
> function as previous day or yesterdayDate?
>  
> thanks,
> 
> KF
> 
> 
>  

  Return to Index