Italian date format

[Piero]

I am using asp-db on a ISP located in the US but I need to input the date in italian format (dd/mm/yyyy).
Using dbMagicCell=",,format=[dd/mm/yyyy]" works well for the grid but not for add and update.

Do you have any solutions?

[Mark]

Piero,

You may need to set the dateformat in dbOptions. See DOC file at:

http://www.aspdb.com/docs/aspdbman.htm#dbOptions

and Revision Log at:

http://www.aspdb.com/whatsnew.asp

What version of ASP-db are you using? What kind of database are you using?
Do you have a dbDBType statement in your program? If so, what is it?

Mark.

------------
Piero at 3/27/00 6:13:39 AM

I am using asp-db on a ISP located in the US but I need to input the date in italian format (dd/mm/yyyy).
Using dbMagicCell=",,format=[dd/mm/yyyy]" works well for the grid but not for add and update.

Do you have any solutions?

[Frank]

You have to give more details in order to get better help. For now, try the following in your asp file -

...Detect user's location

..... apsdb code
if Italy then
X.dbOptions="DateFormat=dd/mm/yyyy,...."
elseif US then
X.dbOptions="DateFormat=mm/dd/yyyy,...."
endif

Note that if you are using Oracle then you have to do a more vigorous conversion. See documentation about DateFormat and Oracle date format.


FK



------------
Piero at 3/27/00 6:13:39 AM

I am using asp-db on a ISP located in the US but I need to input the date in italian format (dd/mm/yyyy).
Using dbMagicCell=",,format=[dd/mm/yyyy]" works well for the grid but not for add and update.

Do you have any solutions?