The calculation is entering data in a format FileMaker can't convert into a date and you then get the ?
y has three values possible: "20", "19", or "18". Where in your calculation do you compute the rest of the year to get a value for the year that is 4 digits such as 1961?
Once you correct y to compute the entire year, use the date function as your final expression:
Date ( m ; d ; y )
as you see:
y = Case (Y1 > 4; "20"; Case (Y1 >2; "19"; Case (Y1 >0; "18"))) & Middle (data;2;2)
so, first Case.... is getting "20"; "19"; or "18"
and other part: & Middle (data;2;2)
so, basically it's 19 & 61 = 1961
Yep missed that, it's just that the text:
The text: "1961-08-08" isn't recognized as a date by FileMaker. Date fields in FileMaker are actually number fields with special formatting to change the number of days since December 31, Year 0000 into a date format. You can actually add and subtract dates in FileMaker as though they are numbers and this can be very useful.
Using the Date function should get things working for you.
it did. but it returned me with the message in calculation that i cannot use list function with LET, so i had to remove all variables and use actual fields and calculations.
You should have been able to use the Let function. I don't see any "list" function in your example, which makes that message a bit odd. You probably had either a ] or ; missing or in the wrong place.