Jump to content

Data formating


This topic is 8559 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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"/>

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

  • 3 weeks later...

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!

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 8559 days old. Please don't post here. Open a new topic instead.

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.