I’m trying to generate a number like this for say, a flight number.
I want daily flight numbers to be something like this:
date of flight + (append, not add) 1 (2, 3, 4, 5 etc) eg: 130820211, 130820212, 120820213 etc
In order to do this, I need to search for that date’s flights, get the flight number, but strip away the date part to be left with the last number to add to. Is there a way to do that? I’ve been messing with it for ages but can’t figure it out within the confines of the expression field.