Formatting date

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…

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)

3 Likes

Thank you, this works perfectly.

2 Likes

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.

1 Like