Formatting date

[Natt_Boarer]

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…

[Suvrutt_Gurjar · Accepted 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)

help.appsheet.com

TEXT()

Format as text

help.appsheet.com

RIGHT()

Rightmost characters of text

[Natt_Boarer]

Suvrutt_Gurjar:

RIGHT(TEXT([Order Date], “YYDDMM”),5)

Thank you, this works perfectly.

[Natt_Boarer]

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))

[Suvrutt_Gurjar]

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

Serial Numbers, If You Must Tips & Tricks 💡

Danger Ahead! In general, sequential numeric identifiers (i.e., serial numbers) are risky in AppSheet: if two users happen to add rows at the same time, both rows could be assigned the same serial number, which could lead to confusion (at the least) or data loss (at the worst). For this reason, serial numbers are strongly discouraged! Basic Serial Numbers One way to implement serial numbers is with a normal (not virtual) column named (e.g.) Serial of type Number and an Initial value expression …

Custom Row Number to generate sequential number , using spreadsheet function Tips & Tricks 💡

Sequential number is not officially supported with AppSheet, but this easy tricks could help some particular business requirement where the app creators need to generate the seq custom number or ID based on the rows, although there would not give much of flexibilities for numbering. Solution. Use Googlespreadsheet Expression of ROW() [Snag_58bbc93] [Snag_58bcb58] Even we have concurrent users, the added new rows will assing ID under usual [ID] field using uniqueid() expression. But spre…

Also following miscellaneous AppSheet references will be useful to you

Guide on How To Create a Community Post Tips & Tricks 💡

Don’t know how to post in this forum. Anyway, I’m a noob and planning my first app. The following how to help needed. How to generate a running serial number for each row in a form. How to display this number back to the user once they submit. Allow update by fetching data only for the given serial number. Thanks. AnanthaPad

Please post back if you are looking for something else.