Calculations

[Guest Sam]

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 :)

[comment 1,777]

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, 2020 by comment

[Guest Sam]

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

[Guest Sam]

The date form is giving an error (?), What can I do?

[comment 1,777]

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).

 

[Guest Sam]

Whenever they type a letter.
I will post

thank yo

PS: I can't attach to the file

[Guest Trevor]

In English:

Whenever they type a letter.
I will post

thank you

PS: I can't attach to the file

[comment 1,777]

Define the field to auto-enter a calculated value, replacing existing value =

Self & If ( Length ( Self ) = 1 ; "." )

 

[Guest Sam]

It works.
Only the date is missing!

Thanks for the patience

[Guest Sam]

I already discovered the error;)

Thanks for everything