Hey, all you happy ASP-developers out there!

I've got a very strange problem.. Im using this string to count the number 
of new users today. It worked in the end of august, but when it turned to 
september, it just ****ed up =). I really dont know whats the problem 
here. Please help me out! Here it is:

"SELECT count(*) as antal FROM Members WHERE datum = #"&Date&"#"

Have a good weekend!
Regards,
Martin Johansson

Change the word Date to this..

Year(date) & "/" & Month(date) & "/" & day(date)

and see if that helps.


It's reversing the date which is why it's stopped working.

31/08/02 cannot be interpreted as another date, where as 01/09/02 can.




-----Original Message-----
From: Martin Johansson [mailto:fjallsemester@h...]
Sent: 06 September 2002 14:01
To: ASP Databases
Subject: [asp_databases] Date-problems... ??


Hey, all you happy ASP-developers out there!

I've got a very strange problem.. Im using this string to count the number
of new users today. It worked in the end of august, but when it turned to
september, it just ****ed up =). I really dont know whats the problem
here. Please help me out! Here it is:

"SELECT count(*) as antal FROM Members WHERE datum = #"&Date&"#"

Have a good weekend!
Regards,
Martin Johansson

_____________________________________________________________________
Please contact I.T. Support if you have received this email in error.
This e-mail has been scanned for all viruses by Star Internet.
_____________________________________________________________________


_____________________________________________________________________
Kingfield Heath Ltd. Email Disclaimer

Confidentiality : This email and its attachments are intended for the
above-named only and may be confidential. If they have come to you in
error you must take no action based on them, nor must you copy or
show them to anyone; please reply to this email and highlight the
error.

Security Warning : Please note that this email has been created in
the knowledge that the internet is not a 100% secure communications
medium. We advise that you understand and observe this lack of
security when emailing us.

Viruses : Although we have taken steps to ensure that this email and
attachments are free from any virus, we advise that, in keeping with
good computing practice, the recipient should ensure they are
actually virus free.
_____________________________________________________________________

YEEEEEES!!! THANKS A LOT TO YOU!! =)
Have a great weekend! =)
/Martin

>From: "Craig Flannigan" <ckf@k...>
>Reply-To: "ASP Databases" <asp_databases@p...>
>To: "ASP Databases" <asp_databases@p...>
>Subject: [asp_databases] RE: Date-problems... ??
>Date: Fri, 6 Sep 2002 13:58:12 +0100
>
>Change the word Date to this..
>
>Year(date) & "/" & Month(date) & "/" & day(date)
>
>and see if that helps.
>
>
>It's reversing the date which is why it's stopped working.
>
>31/08/02 cannot be interpreted as another date, where as 01/09/02 can.
>
>
>
>
>-----Original Message-----
>From: Martin Johansson [mailto:fjallsemester@h...]
>Sent: 06 September 2002 14:01
>To: ASP Databases
>Subject: [asp_databases] Date-problems... ??
>
>
>Hey, all you happy ASP-developers out there!
>
>I've got a very strange problem.. Im using this string to count the number
>of new users today. It worked in the end of august, but when it turned to
>september, it just ****ed up =). I really dont know whats the problem
>here. Please help me out! Here it is:
>
>"SELECT count(*) as antal FROM Members WHERE datum = #"&Date&"#"
>
>Have a good weekend!
>Regards,
>Martin Johansson
>
>_____________________________________________________________________
>Please contact I.T. Support if you have received this email in error.
>This e-mail has been scanned for all viruses by Star Internet.
>_____________________________________________________________________
>
>
>_____________________________________________________________________
>Kingfield Heath Ltd. Email Disclaimer
>
>Confidentiality : This email and its attachments are intended for the
>above-named only and may be confidential. If they have come to you in
>error you must take no action based on them, nor must you copy or
>show them to anyone; please reply to this email and highlight the
>error.
>
>Security Warning : Please note that this email has been created in
>the knowledge that the internet is not a 100% secure communications
>medium. We advise that you understand and observe this lack of
>security when emailing us.
>
>Viruses : Although we have taken steps to ensure that this email and
>attachments are free from any virus, we advise that, in keeping with
>good computing practice, the recipient should ensure they are
>actually virus free.
>_____________________________________________________________________
>




_________________________________________________________________
På MSN hittar du det roliga, intressanta och användbara på internet: 
http://www.msn.se