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

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, 20205 yr by comment

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

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

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

 

Whenever they type a letter.
I will post

thank yo

PS: I can't attach to the file

In English:

Whenever they type a letter.
I will post

thank you

PS: I can't attach to the file

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

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

 

It works.
Only the date is missing!

Thanks for the patience

I already discovered the error;)

Thanks for everything