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