Filtering a Multiline Text field in crystal reports 1

[saran26]

Hi All,

We have a multiline text field with various information such as date,action,username etc.

Is it possible to filter based on the date , and display only the values which matches the date provided ??

Example -

Multiline text in the database contains,

2/11/2008 modify saran
2/21/2008 delete sam
2/11/2008 add subha

If I specify 2/11/2008 as filter to the query, it should display only two rows from the multiline text field.

2/11/2008 add subha
2/11/2008 modify saran

Please help me.

Thanks
Saran

 

[lbass]

Change it to:

if date(trim(mid(memoseg, instr(memoseg,"Time")+17,10))) in {ClearQuest.history_action_timestamp} to
{ClearQuest.history_action_timestamp}+30 then //etc.

In other words, compare dates on both sides of the equation.

-LB