<div>
Could you please give more details?<br />
what is the database?<br />
what is the programming language you are using?
</div>


<div>
Sorry about that; &nbsp;I'm using Crystal Reports XI, and the database is in sql (it's a healthcare database.) &nbsp;I am comparing the date that a medication was stopped (which is a string) to the date of the office visit (which is a datetime). &nbsp;I only want to display medications that have a stop date AFTER the office visit date (so the medication is still current when the patient leaves the clinic).
</div>


<div>
<div class="content wysiwyg-content">
I need to compare 2 date fields; one is a string, the other is a datetime. &nbsp;The string is in the yyyymmdd format. &nbsp;How do I convert these two data types, and then compare them? &nbsp;I will want to display data where the data associated with the string is more recent than the datetime.
</div>
</div>


I need to compare 2 date fields; one is a string, the other is a datetime.  The string is in the yyyymmdd format.  How do I convert these two data types, and then compare them?  I will want to display data where the data associated with the string is more recent than the datetime.

Could you please give more details?
what is the database?
what is the programming language you are using?

Sorry about that;  I&#39;m using Crystal Reports XI, and the database is in sql (it&#39;s a healthcare database.)  I am comparing the date that a medication was stopped (which is a string) to the date of the office visit (which is a datetime).  I only want to display medications that have a stop date AFTER the office visit date (so the medication is still current when the patient leaves the clinic).

Convert str to date and then compare

Software is any set of instructions that directs a computer to perform specific tasks or operations. Computer software consists of programs, libraries and related non-executable data (such as documentation). Computer software is non-tangible, contrasted with computer hardware, which is the physical component of computers. Software written in a machine language is known as "machine code". However, in practice, software is usually written in high-level programming languages than machine language. High-level languages are translated into machine language using a compiler or interpreter or a combination of the two.