Jump to content

Calculations


Recommended Posts

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

Link to post
Share on other sites
Posted (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 by comment
Link to post
Share on other sites
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

Link to post
Share on other sites
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

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

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.