Marc
|
| Posted: 03/19/2003, 11:47 PM |
|
Hello
I read the article of Elena to format dates. It was very clear and I succeeded to format the date. But how to transform more dates on a form? I thought adding a second datefield at OPEN and BEFORE SHOW was sufficient, but that doesn't work.
Before Show
'******** FORMATS *************
'1 - dd/mm/yyyy
'2 - mm/dd/yy
'3 - dd-mm-yyyy
'******************************
flddateA1 = my_date_format(flddateA1, 1)
flddateB1 = my_date_format(flddateB1, 1)
Open
'******** FORMATS *************
'1 - dd/mm/yyyy
'2 - mm/dd/yy
'3 - dd-mm-yyyy
'******************************
'sWhere = replace (sWhere, "'"&GetParam("dateA")&"'", "#"&GetParam("dateA") "#")
'sWhere = replace (sWhere, "'"&GetParam("dateB")&"'", "#"&GetParam("dateB") "#")
Thanks in advance
Marc
|
|
|
 |
Peter
|
| Posted: 03/20/2003, 3:15 AM |
|
Marc, where can I find that article of Elena to format dates?
I still have a lot of problems with (european) dates in CC / Access/ ASP.
A final article for novices would be very welcome. This costs me hours and hours of frustration.
|
|
|
|
Marc
|
| Posted: 03/20/2003, 4:25 AM |
|
Hi Peter
You can find the article at http://www.gotocode.com/art.asp?art_id=132&
There is an exemple included. Besides the instructions above it's also good to view the global.asa
Best regards
Marc
|
|
|
|
|
