chrisb
Posts: 7
|
| Posted: 02/02/2006, 9:51 PM |
|
I have a case where the leading zero of a date used as a link parameter is being dropped. I'm using CCS3 latest update, ASP, Access, WinXP.
Link parameter is:
Source type: Expression
Parameter source: Date()
Parameter name: s_report_date
The link which results is:
report_name.asp?s_report_date=3/02/2006
The leading zero of the date is dropped. If I display date() in a label, 03/02/2006 is displayed. Full date is Feb 3rd 2006.
Anyway, the result of this is the following message when linked page is displayed:
Script error detected at line 6502.
Source line: ResultDateArray(DAY_POS) = CInt(DatePartStr)
Description: Type mismatch: 'CInt'
Other settings I have are:
Date display format in Project Locales settings: dd/mm/yyyy
Date formats in Data Source where clause: dd/mm/yyyy
Date format in Access: Short Date (dd/mm/yyyy)
If I change the computer date to something like 17/02/2006 all is fine. I've also tried using formatdatetime function with no change. Just seems to be dropping the leading zero in the link. Any thoughts please?
|
 |
 |
|
