p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

crystal_reports thread: add date in crystal report


Message #1 by "Sek Tee Yong" <air_salak@h...> on Fri, 18 Oct 2002 10:43:06
Hi all,

my current dB date format is in text form. It's format is YYYYMMDD. Now i 
need to select all records which is going to expired or already expired 
and display it in the crystal report.

How can i convert today's date into the above format and how can i apply 
it to the selection formula.

If i am to use the SQL query, how can i do exactly like the above? Any 
inspiration is much appreciated.

john

  Return to Index