Airtable newbie here. I have been trying to work out this formula for hours now and I can’t figure out what is wrong. I want to create a custom SKU based on when it was set up. This is my formula that is erroring:
The SKU should start with ‘EY’ and then a two digit number where the first digit is the year (1 for 2021, 2 for 2022, etc.) and the second digit is the quarter.
I have plugged each subsection in separately and each work by themselves but when I string them with & it errors out. I have tried both Concatenate and &. I’m sure it’s something very simple I"m doing wrong but I’ve read the documentation many times over and can’t figure it out.
Thank you for your suggestions! I didn’t know what the documentation meant by straight and curly quotes. I thought they meant “EY” vs ‘EY’. But then I remembered my old college coding days and needing to use Courier font if I was coding in Word and pasting it in.
I was playing with DATETIME_FORMAT and you were correct, my previous formula was returning the letter Z. But I wasn’t getting ‘YYYY’ to work either. Your way is much cleaner so I’ll give that a go. Thank you so much for your guidance.