Recent content by crytalbria

SQL Expression Field, Hello, I am attempting to build a SQL Expression Field with multiple 'FROM' (subquery) Below are my examples - Is this not supported by SQL Expression Fields? I can't see to find much information on them. ( SELECT Top 1 Current_status From RV_PF Where RV_PF.Code =...

Thank you for your time. I've been knocking my head against the wall on this one. I have a single value number parameter. I would like the below formula output to change color when the number entered in the parameter is >= its value. If Not OnFirstRecord And {@GapFromDate} >=...

LB - That is a fine bit of code.. Thank you very much. I need to sit down and work it out.

Thank you, LB for your assistance - If I may trouble you.  If the string doesn't have 'Camp' within the string, it only returns the last value.  Example, if the string is: Secondary, Mailing, Billing Or Billing, Historical, Directory The formula will return only: Billing and Directory...

I'm finding this somewhat troublesome to solve - How can I remove a value within a string, with the position continuing to change?  The value will always start with 'Camp, ending with ')' or '),' Example  Camp(anytxtvalue), or  Camp(anytxtvalue)  Data before: Home, Camp(alpha), Billing, Mailing...

Thank you, LB That did the trick.

Hello Tek-Tips I created the following formula to return the total days between two dates. I would like to change the font color when the total days between the two dates are equal/greater than 60. unfortunately, I've been unable to complete this task was utilizing 'onfirstrecord' within my...