comparing date in hepcar table

jlindsey

<p>I'm trying to compare the term date(yatrmd) in the HEPCAR table.</p>
<p> </p>
<p>the date is stored delimited by commas...can someone tell me the syntax for this...</p>
<p>I tried this below and it throws an error..</p>
<p>I have tried breaking the date up using substring and it still will not work.</p>
<p> </p>
<p> </p>
<p>and lwsys.isodates(yatrmd) <= (current date - 2555 days)</p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p>Thanks</p>

Virgil Dodson

<p>Do you have an example of the date and where it's stored?</p>