Date input conversion with CWP

June 24, 200520 yr

Newbies

Hi - I'm getting to grips with FMSA custom web publishing and have a question regarding the conversion of a input date field on a form, from dd/MM/yyyy, to the standard "fm" format of MM/dd/yyyy. I've researched enough to realise this should be done client side with JavaScript but my javascript skills aren't that advanced. Does anyone know how to achieve this?

So far I figure that the date field submitted to the database (Booking Date in MM/dd/yyyy format), should be a hidden input field on the form. Then on submitting the form, the field the user completed, tempDate (in dd/MM/yyyy format) should be converted using javascript to MM/dd/yyyy and copied to the Booking Date field.

The other complication is that there are several forms which contain the different products the user may choose to book, not just a single form with one product.

Each form is named according to the following:

<xsl:attribute name="name">prodform<xsl:value-of select="$record/fmrs:field[@name = 'ID']/fmrs:data[1]"/></xsl:attribute>

which creates forms named prodform2001, prodform2002, prodform2003 etc depending on the catalogue ID.

The xsl file has the form defined as:-

<xsl:attribute name="action">bookedOK.xsl</xsl:attribute>

<xsl:attribute name="name">prodform<xsl:value-of select="$record/fmrs:field[@name = 'ID']/fmrs:data[1]"/></xsl:attribute>

... how do I fill out the Booking Date field with MM/dd/yyyy values?...

... display what's on sale...

... temporary input field for Booking Date in dd/MM/yyyy format

</table>

</form>

I'd be grateful for any suggestions on the best way to do this from within an xsl template file.

As an aside, the conversion of booking dates when displayed on the webpage has been done by using an xslt function and seems to work well:

<xsl:for-each select="fmrs:field[@name = 'Booking Date']/fmrs:data[1]">

<xsl:value-of select="fmxslt:convert_datetime('MM/dd/yyyy','EEE dd/MM/yy',.)"/>

</xsl:for-each>

Thanks for any help you can give me and cheers...

June 27, 200520 yr

Hi, d! Welcome to FMFORUMS! Now, until someone posts exactly what you want (I'm afraid I haven't delved into xml/xsl yet and my JS is probably worse than yours), can you use FM to parse your date and re-arrange the components using CALC fields?

--ST

June 27, 200520 yr

You can use some Javascript to reformat the date fefore the Form is submitted.

<html><head>

<script>

function moddate()

   {

   formdate = document.myform.mydate.value.split("/");

   document.myform.mydate.value = formdate[1] + "/" + formdate[0] + "/" + formdate[2];

   document.myform.submit();

   }

</script>

</head>

<body><form name="myform" action="FMPro" method="POST" onsubmit="moddate(); return false;">

<input type="hidden" name="-db" value="mydb.fp5">

<input type="hidden" name="-format" value="mypage.html">

Enter date (dd/mm/yyyy): <input type="text" name="mydate" value="">

<input type="submit" name="-new" value="Submit Form">

</form></body></html>

Good Luck.

Garry