AndyW
|
| Posted: 03/18/2003, 4:26 AM |
|
Our polish regional short date setting is 2003-03-17 (rrrr-mm-dd)
I am using ASP MSAccess and CCS2 B4.
I want to make condition that only articles with valid date ("termin" higher
or equal to today) show in my grid.
When I am using parameter window and put Date() as an expression it shows
correctly
termin = #Date()# in Data Source Window
but ends up with an '2003-03-17 00:00:00' in SQL error on www page
!!! so it cuts "#" signs off !!!
I have made all date formats to standard dd/mm/yyyy also the regional
settings o Windows but it didnt solve the problem.
Is there a method for creating new date templates for CCS2?
Anybody can help ??? I am completely lost. Have also tried to format value
using SQL but everything crashes or doesn't work at all.
|
|
|
 |
DonB
|
| Posted: 03/18/2003, 5:12 AM |
|
CCS uses ADO (not DAO) to connect to Access. DAO used the "#" delimiters
for dates - now you should just use quotes to pass date strings.
Also you can type in the date format you want - you are not limited to the
values in the dropdown lists. you should use "yyyy-mm-dd" (you indicated
"rrrr" for the year and it's not clear to me if that's merely a typeing
error).
If you put "yyyy-mm-dd" in the "Format" property of your date fields, you
should be OK. There is also the "DBformat" property but I always leave that
blank. Finally, type "yyyy-mm-dd" into the Project Settings properties for
the Date Display Format.
DonB
"AndyW" <a.wisniewski@interia.pl> wrote in message
news:b573ai$num$1@news.codecharge.com...
> Our polish regional short date setting is 2003-03-17 (rrrr-mm-dd)
>
> I am using ASP MSAccess and CCS2 B4.
> I want to make condition that only articles with valid date ("termin"
higher
> or equal to today) show in my grid.
> When I am using parameter window and put Date() as an expression it shows
> correctly
> termin = #Date()# in Data Source Window
> but ends up with an '2003-03-17 00:00:00' in SQL error on www page
> !!! so it cuts "#" signs off !!!
>
> I have made all date formats to standard dd/mm/yyyy also the regional
> settings o Windows but it didnt solve the problem.
>
> Is there a method for creating new date templates for CCS2?
>
> Anybody can help ??? I am completely lost. Have also tried to format value
> using SQL but everything crashes or doesn't work at all.
>
>
|
|
|
|
AndyW
|
| Posted: 03/19/2003, 6:48 AM |
|
Hi, rrrr is simply yyyy but in polish localization, sorry for that.
I have cleaned and set all entries to yyyy-mm-dd and in server connection
settings changed from default with time to date only.
Then your guidelines helped. IT finally works fine !
I think However CCS should take regional setting as default automatically in
such a case as many countries can use the soft which I think is better and
better.
THANKS
AndyW
Użytkownik "DonB" <dbweb2@premiersi.com> napisał w wiadomości
news:b5760b$th4$1@news.codecharge.com...
> CCS uses ADO (not DAO) to connect to Access. DAO used the "#" delimiters
> for dates - now you should just use quotes to pass date strings.
>
> Also you can type in the date format you want - you are not limited to the
> values in the dropdown lists. you should use "yyyy-mm-dd" (you indicated
> "rrrr" for the year and it's not clear to me if that's merely a typeing
> error).
>
> If you put "yyyy-mm-dd" in the "Format" property of your date fields, you
> should be OK. There is also the "DBformat" property but I always leave
that
> blank. Finally, type "yyyy-mm-dd" into the Project Settings properties for
> the Date Display Format.
>
> DonB
>
>
> "AndyW" <a.wisniewski@interia.pl> wrote in message
>news:b573ai$num$1@news.codecharge.com...
> > Our polish regional short date setting is 2003-03-17 (rrrr-mm-dd)
> >
> > I am using ASP MSAccess and CCS2 B4.
> > I want to make condition that only articles with valid date ("termin"
> higher
> > or equal to today) show in my grid.
> > When I am using parameter window and put Date() as an expression it
shows
> > correctly
> > termin = #Date()# in Data Source Window
> > but ends up with an '2003-03-17 00:00:00' in SQL error on www page
> > !!! so it cuts "#" signs off !!!
> >
> > I have made all date formats to standard dd/mm/yyyy also the regional
> > settings o Windows but it didnt solve the problem.
> >
> > Is there a method for creating new date templates for CCS2?
> >
> > Anybody can help ??? I am completely lost. Have also tried to format
value
> > using SQL but everything crashes or doesn't work at all.
> >
> >
>
>
|
|
|
|
DonB
|
| Posted: 03/19/2003, 10:36 AM |
|
Glad you got it working. There are a couple of nits (at least) with the way
CCS does dates. besides what you ran into, the Date Picker may incorrectly
set the year to "20" if you are not careful about getting all the date
formats the same. My contention is that blindly applying the date format to
a string is poor implementation if it produces an invalid date as its
output. I've taken this up with Yes and maybe it will be improved in the
future.
DonB
"AndyW" <a.wisniewski@interia.pl> wrote in message
news:b5a00j$36k$1@news.codecharge.com...
> Hi, rrrr is simply yyyy but in polish localization, sorry for that.
>
> I have cleaned and set all entries to yyyy-mm-dd and in server connection
> settings changed from default with time to date only.
> Then your guidelines helped. IT finally works fine !
>
> I think However CCS should take regional setting as default automatically
in
> such a case as many countries can use the soft which I think is better and
> better.
>
> THANKS
> AndyW
>
> Użytkownik "DonB" <dbweb2@premiersi.com> napisał w wiadomości
>news:b5760b$th4$1@news.codecharge.com...
> > CCS uses ADO (not DAO) to connect to Access. DAO used the "#"
delimiters
> > for dates - now you should just use quotes to pass date strings.
> >
> > Also you can type in the date format you want - you are not limited to
the
> > values in the dropdown lists. you should use "yyyy-mm-dd" (you
indicated
> > "rrrr" for the year and it's not clear to me if that's merely a typeing
> > error).
> >
> > If you put "yyyy-mm-dd" in the "Format" property of your date fields,
you
> > should be OK. There is also the "DBformat" property but I always leave
> that
> > blank. Finally, type "yyyy-mm-dd" into the Project Settings properties
for
> > the Date Display Format.
> >
> > DonB
> >
> >
> > "AndyW" <a.wisniewski@interia.pl> wrote in message
> >news:b573ai$num$1@news.codecharge.com...
> > > Our polish regional short date setting is 2003-03-17 (rrrr-mm-dd)
> > >
> > > I am using ASP MSAccess and CCS2 B4.
> > > I want to make condition that only articles with valid date ("termin"
> > higher
> > > or equal to today) show in my grid.
> > > When I am using parameter window and put Date() as an expression it
> shows
> > > correctly
> > > termin = #Date()# in Data Source Window
> > > but ends up with an '2003-03-17 00:00:00' in SQL error on www page
> > > !!! so it cuts "#" signs off !!!
> > >
> > > I have made all date formats to standard dd/mm/yyyy also the regional
> > > settings o Windows but it didnt solve the problem.
> > >
> > > Is there a method for creating new date templates for CCS2?
> > >
> > > Anybody can help ??? I am completely lost. Have also tried to format
> value
> > > using SQL but everything crashes or doesn't work at all.
> > >
> > >
> >
> >
>
>
|
|
|
|
|
