Let ( [ T = yourTextFieldHere ;
N = right ( "00" & left ( T ; 3 ) + 10 ; 3 ) ;
Y = Right ( T ; 2 ) ];
N & middle ( T ; 4 ; 4 ) & Y
Apologies for the stupid question, where can I find let in the script options?
in the script you select set field(yourtextfield) and in the calculation you are using what phil said
Where can I find let in the script options?
You don't; Let() is a function that you use in the result expression, i.e.
Set Field [ target field: YourTable::yourTextFieldHere ; result calculation: PhilModJunk's calculation ]
And if you have a batch of records to update this way, you might use Replace Field Contents.
Let can look a little confusing at first... at least for me, it was four years ago when I was new to FileMaker. It was actually @philmodjunk who helped me with it also. Look here... it was my first post in this community But to solve yours what @philmodjunk is saying will work if you want to just add things like you ask. I am sensing that you want more than what you ask. Because you are working with a date concept, you need more than just some math. That is because math for actual dates will not work on your abbreviated string. I am assuming that if you have 225-Aug16 calculate to 235-Aug17 It will be fine. However, if you try that on 245-Aug31 and get 255-Aug32, I don't think that is what you want. I think you would want 255-Sep1 or 255-Sep01. So I played around with this. Back to Let... when it was shown to me it looked complicated, I worked with it, and now I see it is an invaluable tool for creating complex calculations for fields and scripts. I tried to show what user above helped with in a let and tried to describe it how I have learned it thinking maybe it can help you also. But I also included the way that will calculate the date properly.