Wrox Home  
Search P2P Archive for: Go

  Return to Index  

access_asp thread: dates URGENT


Message #1 by richhern35@h... on Thu, 30 May 2002 12:42:16
I am finishing a project in Italy in which i am finding some problems with 
my dates. I found out that if i assign the variables with a date in the 
following way the program works just fine:

enddate=#08/20/2002#


However my program needs to get a date from a form to process my 
calculations. I can not used Cdate() function to convert the text string 
from my form to date because it converts it to italian format and the 
access database always use the english version. 

arrdate=Request.Form("arrivald") 
arrmonth=Request.Form("arrivalm")
depmonth=Request.Form("depmonth") 
beg= arrmonth & "/" & arrdate & "/" & "2002"

I would love to convert the beg date text string to a date format, 
However, I can not used the Cdate function because it converts the day to 
Italian and the access database expects it as in english. I tried the 
following. 

arrdate=Request.Form("arrivald") 
arrmonth=Request.Form("arrivalm")
depmonth=Request.Form("depmonth") 
beg= arrmonth & "/" & arrdate & "/" & "2002"
begdate=#beg#

but it does not work. I know that if i used properly the # operators i 
migh get my program to work properly. 

enddate=#08/20/2002#

If i get this date thing going right my program will work  great. 

Thank you in advance for your help 
Sincerely,
Ricardo Hernandez

  Return to Index