Data formating

[pcourterelle]

I realize this question has been asked/answered a million times, but I'll be dammned if I can get it to work properly...I almost hate to ask...

Have record page that displays production dates for various projects. In the FMP layout the dates are formatted to display as:

Saturday March 20, 2001

On the web, the display is

3/20/2001

I've included the a -lay tag as below, I've also tried the [field-field: fieldname format] to no avail...

adivce is always appreciated...

cheers

pc

<form action="FMPro" method="post">

<input type="hidden" name="-db" value="Schedule_2000.FP3" />

<input type="hidden" name="-Lay" value="single_record" />

<input type="hidden" NAME="-error" VALUE="error.html"/>

[Vaughan]

Easiest way is to make a calculation field in the database that converts the date to text in the format required. Then display this text field on the werb page.

[pcourterelle]

ahhh...thanks...seems like a clunky way to do it, having two fields for each one just to get the format you want...but you're right, it does seem to be the simplest...

thanks again

(ps..I must say this web site has been a great resource...just ploughing through questions/answers has been a big help...keep up the good work..)

pc

[Mark4158]

You have helped me with my question as well.

But...

Wouldn't it be great if CDML had better formatting tags right within it so that we didn't have to use calc fields as a work around

[spragueg]

It works for me with out calculations. Are your date fields formated correctly on the specified layout?

[Rainer]

quote:

---

Easiest way is to make a calculation field in the database that converts the date to text in the format required. Then display this text field on the werb page.

---

Works fine so far. But you're in big trouble if you get input for that field, and that data are formatted the same way as your calculated output (e.g. because you're using them in the value part of an input field). Even if you change nothing, FileMaker won't accept them!

I finally split the date into three parts (day, month, year) for in- and output. Works fine so far, but what shall I do with numbers? Remember: in Germany we use decimal commas and the point as thousands separator!

[Anatoli]

quote:

---

Originally posted by Rainer:

Works fine so far. But you're in big trouble if you get input for that field, and that data are formatted the same way as your calculated output (e.g. because you're using them in the value part of an input field). Even if you change nothing, FileMaker won't accept them!

I finally split the date into three parts (day, month, year) for in- and output. Works fine so far, but what shall I do with numbers? Remember: in Germany we use decimal

commas

and the

point

as thousands separator!

---

So are we in Czech Rep. But we are also using our weird 8 bit characters and then the real fun starts. FM does not like that at all....