Guest Sam Posted June 9 Share Posted June 9 I'm a Filemaker beginner and I can't do any calculations, could you please help. The first calculation was to add one. (dot) the middle letter. The field is called middle_name The second calculation was to change the date to DD-MM-YYYY, by importing the data it is MM-DD-YYYY Thank you all :) Quote Link to post Share on other sites
comment 1,712 Posted June 9 Share Posted June 9 (edited) 18 minutes ago, Guest Sam said: The second calculation was to change the date to DD-MM-YYYY, by importing the data it is MM-DD-YYYY If you have a Text field containing imported dates in MM-DD-YYYY format, and you want to convert them to valid dates in the format used by your file, then use a calculation field (result is Date) = Let ( v = Substitute ( ImportedDate ; "-" ; ¶ ) ; Date ( GetValue ( v ; 1 ) ; GetValue ( v ; 2 ) ; GetValue ( v ; 3 ) ) ) 18 minutes ago, Guest Sam said: The first calculation was to add one. (dot) the middle letter. Sorry, no clue what you mean by that. --- P.S. Please update your profile to reflect your version and OS so that we know what you can use. Edited June 9 by comment Quote Link to post Share on other sites
Guest Sam Posted June 9 Share Posted June 9 Thank you very much for the answers! When a person enters a letter in the field (middle_name) he automatically adds one. Ex: R. S. P. K. L. I'm using Filemaker 19 and the windows version Quote Link to post Share on other sites
Guest Sam Posted June 9 Share Posted June 9 The date form is giving an error (?), What can I do? Quote Link to post Share on other sites
comment 1,712 Posted June 9 Share Posted June 9 11 minutes ago, Guest Sam said: When a person enters a letter in the field (middle_name) he automatically adds one. Do you want this to happen only if they enter a single letter, or every time? 8 minutes ago, Guest Sam said: The date form is giving an error (?), What can I do? I don't know. Why don't you post a simple file showing the problem (and nothing else). Quote Link to post Share on other sites
Guest Sam Posted June 9 Share Posted June 9 Whenever they type a letter. I will post thank yo PS: I can't attach to the file Quote Link to post Share on other sites
Guest Trevor Posted June 9 Share Posted June 9 In English: Whenever they type a letter. I will post thank you PS: I can't attach to the file Quote Link to post Share on other sites
comment 1,712 Posted June 9 Share Posted June 9 Define the field to auto-enter a calculated value, replacing existing value = Self & If ( Length ( Self ) = 1 ; "." ) Quote Link to post Share on other sites
Guest Sam Posted June 9 Share Posted June 9 It works. Only the date is missing! Thanks for the patience Quote Link to post Share on other sites
Guest Sam Posted June 9 Share Posted June 9 I already discovered the error;) Thanks for everything Quote Link to post Share on other sites
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.