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 :) Link to post Share on other sites
comment 1,743 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 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 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? Link to post Share on other sites
comment 1,743 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). 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 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 Link to post Share on other sites
comment 1,743 Posted June 9 Share Posted June 9 Define the field to auto-enter a calculated value, replacing existing value = Self & If ( Length ( Self ) = 1 ; "." ) 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 Link to post Share on other sites
Guest Sam Posted June 9 Share Posted June 9 I already discovered the error;) Thanks for everything Link to post Share on other sites
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now