which function is suitable? (check first digit of field)

[ioannagr]

 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!

[jonathandienst · Accepted solution]

Like this:

if(Match(Left(id, 1), '3', '4'), <expression if true>, 'no date change')