I’m trying to get my date to format correctly to be a scrambled batch code.
I want it to read YDDMM where Y= year I.e currently 1 (2021)
I’ve managed to get it to show the whole date using concatenate but I’m struggling to omit the YYY and just get the year.
This will then be combined with a prefix & suffix which I seem to have working ok.
Any suggestions…
Solved! Go to Solution.
Please take a look at the TEXT() functions.
In general, your desired format could be achieved by something like
RIGHT(TEXT([Date Column], “YYDDMM”),5)
Please take a look at the TEXT() functions.
In general, your desired format could be achieved by something like
RIGHT(TEXT([Date Column], “YYDDMM”),5)
Thank you, this works perfectly.
Would you know how I can count the number of batches on one date and then add the count number after the date?
E.g: Prefix YYDDMM 1 or PREFIX YYDDMM 2
My formula currently is - Concatenate ([PREFIX], RIGHT(TEXT([Date Completed], “YYDDMM”),5))
If you are trying to add some kind of serial number sequencing to batches, I would request you to take a look at the following posts by @Steve and @tsuji_koichi
Also following miscellaneous AppSheet references will be useful to you
Please post back if you are looking for something else.
User | Count |
---|---|
39 | |
28 | |
23 | |
23 | |
13 |