If with a search string

[coxanagi]

Hello!

I want to display in a Text Object a Date, only for some companies. I can identify the foreign companies by its ID, the foreign companie's ID  start with 'PE_____' and the national companie's ID start with 'PN_____' So I need to substract 30 days to foreign companie's date y display it. I tried it with a search string but something goes wrong.

This is the expresison that I tried to use

= if ( [COMP_ID]="PE*", 'Date ' &Chr(10)&(Date(MIN( [Registration Date])-30) ) , 'Date '&Chr(10)&(Date(MIN([Registration Date]) ) ) )

[Anonymous · Accepted solution]

Hello,

you can try with  [COMP_ID] like 'PE*'

Elena

[coxanagi]

It works Thank you!!