Changing the way timestamp is displyed in a note

November 30, 200916 yr

Background:

New to Filemaker pro, got the hold of the basics, but yet to learn the correct "Filemaker Language".

Problem.

I've been using the "contact management" template that comes with Filemaker Pro 10 Advanced.

The "Notes function" creates a timestamp when the note is being made.

It will print out "11/30/2009 2.23pm by FredYoung"

The timestamp is made from a calculation:

"Month ( Date_Created ) & " / " & Right ( Year ( Date_Created ) ; 2 ) & "By: " & UserName_Created" were "Date_Created" is a "Date-field" with Auto-Enter Creation Date.

What I need is for the print out to be "DD/MM/YYYY 2.23pm by FredYoung" instead.

To look on the entire function, just open the "contact management" template (or starter solution at it's called) that comes with Filemaker Pro 10 Advanced (Don't know if it comes as standard but I would guess so.)

Is there maybe a way to change a setting in Filemaker Pro to change "standard date display"? I haven't manage to find it... Or do I need to do a new/change calculation?

Some help or a point in the right direction, please?

Thanks

November 30, 200916 yr

So you have:

"The timestamp is made from a calculation:

"Month ( Date_Created ) & " / " & Year ( Date_Created ) & "By: " & UserName_Created" were "Date_Created" is a "Date-field" with Auto-Enter Creation Date.

What I need is for the print out to be "DD/MM/YYYY 2.23pm by FredYoung" instead."

You have missed Day and Time in formula.

Must be:

Day ( Date_Created) & " / " & Month ( Date_Created) & " / " & Year ( Date_Created ) & " at " & Hour (Time_Created) & " }:( " & Minute (Time_Created) & " by " & UserName_Created.