dhodgdon
Posts: 80
|
| Posted: 04/14/2005, 7:01 PM |
|
I have set the MS Access database control as date and format as long date, set CCS project date setting as LongDate, set the control data type as date and the control format as LongDate. It doesn't matter if I use the CCS date picker or manually enter the day and date, when I submit the form, I receive the error:
The value in field Hotel Arrival is not valid. Use the following format: LongDate.
I have tried other formats that include the day of the week in them and they all fail with the error message complaining that I didn't enter the information in the correct format. Only formats without the day of the week seem to work. Any ideas? I very much want the day of the week included if possible.
_________________
Regards,
David Hodgdon
|
 |
 |
Nicole
Posts: 586
|
| Posted: 04/15/2005, 2:03 AM |
|
David,
It may happen if LongDate format set in Regional Options of your system does not match Access LongDate format. As a solution do not select LongDate from Format property list but type in the format accepted by Access, e.g.
Format: mm-dd-yyyy HH:nn:ss
_________________
Regards,
Nicole |
|
|
|
peterr
Posts: 5971
|
| Posted: 04/15/2005, 2:11 AM |
|
I think that this may be a bug. You can contact product support to check if they could provide a solution. (I can check with developers once such issue is submitted and confirmed)
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
dhodgdon
Posts: 80
|
| Posted: 04/15/2005, 3:51 AM |
|
Thanks Nicole & Peter,
Nicole, I did exactly what you suggested before I posted to the forum and had no success.
Peter, I will submit a bug report and repost here to alert you.
_________________
Regards,
David Hodgdon
|
|
|
|
dhodgdon
Posts: 80
|
| Posted: 04/16/2005, 5:28 AM |
|
Yes Software tech support provided a work around to this problem. The CCS date picker doesn't recognize the formatted date on open so it defaults to the current date. It does correctly put the selected date into the control and it is formatted properly. I have asked tech support for help with this and posted on the Java forum. Otherwise it works great.
"ddd" and "dddd" day formats are not currently supported by CCS. The solution is to modify generated code in Common.asp file:
1. To class clsCCSDateConstants -> Private Sub Class_Initialize() function add
...
DateMasks("ddd") = 0
DateMasks("dddd") = 0
End Sub
2.to CCParseDAte function add another CASE operator:
...
Case "ddd", "dddd"
Dim DayArray, DayNumber, DayName
DayNumber = 0
DayName = UCase(DatePartStr)
If MaskPart = "ddd" Then _
DayArray = CCSDateConstants.ShortWeekdays _
Else _
DayArray = CCSDateConstants.Weekdays
While DayNumber < 6 AND UCase(DayArray(DayNumber)) <> DayName
DayNumber = DayNumber + 1
Wend
If DayNumber = 6 Then
If UCase(DayArray(6)) <> DayName Then _
Err.Raise 4000, "Common Functions. ParseDate function","Mask mismatch."
End If
_________________
Regards,
David Hodgdon
|
|
|
|
|
