I am trying to convert over from Airtable. I have a field I am stumped on!
I need "MMYY" returned as 0523 for May 2023 or 1223 for December 2023 for example. This becomes a part of my auto numbering.
In Airtable the formula is simple, but that doesn't seem to work here: DATETIME_FORMAT({First Contract Date}, 'MMYY')
This doesn't work here.
I've Tried: CONCAT(MONTH([Contract Date]),RIGHT([Contract Date],2)), but this returns 1223 ok, but for May I only get 523. I need the leading zero just for the sake of keeping everything consistent.
I've tried an if statement, but get the error that text and number can't be used together.
Can anyone help???