Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to check all ids and if they begin with 3 or 4 assign them a certain date and otherwise state that no change is made
So something like that,
if( id begins with 3 or 4, "date is this", "no date change")
so im looking for a field function but i cant figure out which one.
Thanks in advance!
Like this:
if(Match(Left(id, 1), '3', '4'), <expression if true>, 'no date change')
Like this:
if(Match(Left(id, 1), '3', '4'), <expression if true>, 'no date change')