Date comparison

[dbltt25]

I have 2 dates that are being written into 2 memo fields. I need to verify if the current date is within those two dates in the memo fields. I know I can't use memo fields in any formulas. Does anybody have any idea for a work around on this?? Basically I need to do a date comparison in memo fields. UGH...

Any help is appreciated as always!!
Thanks

 

[kenhamady]

Sorry, only option is to NOT put them into memo fields. Nothing you can do with a memo other than see if it is null. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal

 

[MalcolmW]

Change the data type of the memo field to something with less than 255 characters, using CAST in either a view, stored procedure, or Crystal Query. Malcolm
Remember, if it wasn't for electricity, we'd be surfing the net by candlelight.