date formats

[monki]

hi

i am working with uk date formats (dd/mm/yy) however the server the site is
hosted on is in the us(mm/dd/yy) format
i am using the following to convert the ddates

gigdateuk = day(rs1("Date")) & "/" & month(rs1("Date")) & "/" &
year(rs1("Date"))%>
Response.Write gigdateuk

this works ok

however i am building a page that allows the record to be edited or a new
one added

how do i convert this back to us(mm/dd/yy) format when i post the form

thanks in advance

j

 

[monki]

thanks 4 that Alan

still having a few problems, im pretty new to asp so still tryin to figure
out how things work

should that code work with ms access?

ideally i want the user of the interface form to type in dd/mm/yy (into 1
field)

i am passing this value through a form and then trying to convert this into
mm/dd/yy on the add/edit pages. should this work with that line of code?

its been a long day so i might be missing somthing obvious in my code, is
how im trying to do it correct?

thanks

j

 

[Bob Barrows]

Access online help (in the Jet SQL section) says that date literals must be
passed in US format: m/d/yyyy. Several on this newsgroup have pointed out
that the yyyy-mm-dd ISO format works as well. Personally, I prefer the
latter.

Basically you need to use sting functions to do the conversion to whichever
format you choose to use. It looks like you are already familiar with these,
so I'm really not sure what your problem is.

Bob Barrows