date format

[skc]

I have a FP form with a hidden field with the attributes:
Name=date, Value=<%=date()%>. I checked with my ISP, all
the locale settings are set to UK (which I want!) - i.e.
dd/mm/yyyy. What i notice is that if the dd is <10, then
the format becomes mm/dd/yyyy, and when dd>10 then the
format is OK dd/mm/yyyy.

What is the formatting thing I need to use for <%=Date()%>
so that it get's saved to my Access table in the correct
format?

Please help.

Thanks.

skc

 

[Jim Buyens]

Try:

value="<%=month(now) & "/" & day(now) & "/" & Year(now)%>"

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------