This is my record selection formula:


{enc.enc_timestamp} in {?Date Range} and
{provider_mstr.description} in {?Provider} and
{enc.billable_ind} = "Y" and
{enc.clinical_ind} = "Y" and

({proc.cpt4_code_id} = "99201" or {proc.cpt4_code_id} = "99202" or {proc.cpt4_code_id} = "99203" or {proc.cpt4_code_id} = "99204" or {proc.cpt4_code_id} = "99205" or
{proc.cpt4_code_id} = "99211" or {proc.cpt4_code_id} = "99212" or {proc.cpt4_code_id} = "99213" or {proc.cpt4_code_id} = "99214" or {proc.cpt4_code_id} = "99215" or
{proc.cpt4_code_id} = "99241" or {proc.cpt4_code_id} = "99242" or {proc.cpt4_code_id} = "99243" or {proc.cpt4_code_id} = "99244" or {proc.cpt4_code_id} = "99245")

and
(DateDiff("h",{enc.enc_timestamp},{proc.create_timestamp}) > 23)

I am having problems with the last bit after the last 'and'. How do I select top 1 proc.create_timestamp where cpt4_code_id = 'any of the above' sorted by create_timestamp ascending?

Can I use SQL in Crytsal formula editor? Thank you in advance!