Date Conundrum

[Dean]

hi there

I am pulling the date out of a sql2000 database where it is showing in american format 12/20/2002 but in dreamweaverMX i have binded the date to uk format 20/12/02.

so far so good.

I have stuck a link to a detail page on using the data as the paramaeter for the results on the next page.

the problem being is that it puts the date in 12/20/02 which produses no results as their is no record showing this date in the recordset on that page as it is not in the right format.

any suggestions?:confused: :confused:

[Leeus]

Just before your comment try putting in <% session.LCID = 2057 %>

[Dean]

you mean at the top of the page or just in front of the recordset or the link.

im a bit brain dead this morning

[Leeus]

Dreamweaver tries to set it elsewhere so to be sure put it just after the DW code that sets it or put it before every date to be sure.

[Dean]

Thanks Leeus

your a life saver I thought i was going to be here all morning headbutting the screen

nice one:thumbsup: :thumbsup: :thumbsup: :thumbsup: :D :D