formatting standard on projects exclusively for an American audience,
you might never run across this problem. I've worked around it by
always inputting a date (from a form) in day month year parts (or
splitting it up into the parts if it's a _javascript_ style calendar),
and then connocating them into a single string in the format
year-month-date, and then run CreateODBCDate() on that string.
I've found this will work reliably no matter how the server is set up,
dd/mm/yyyy or mm/dd/yyyy, because i *think* CF(at least CF5) set up on
a server using the european date system will try to make a european
date out of the string first. (Thank you very much!) At least that's
been my experience. So it can be a real mess if you're not sure where
your app will be deployed, on a server in America or on a server
elsewhere.
On Tue, 24 Aug 2004 21:11:04 -0400, Ewok <[EMAIL PROTECTED]> wrote:
> if i understand what you mean....
>
> try using the dateformat in your <cfset>
>
> <cfset date1=DateFormat("02/08/2004", "dd/mm/yyyy")>
> <cfset date2=DateFormat("12/08/2004", "dd/mm/yyyy")>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
