Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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]) ) ) )
Hello,
you can try with [COMP_ID] like 'PE*'
Elena
It works Thank you!!