Changing the way timestamp is displyed in a note

[Fred Young]

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

[Peter (duksis3)]

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.

If you want exactly that date format. And You need another auto enter Creation Time field.